- 论坛徽章:
- 0
|
权限没有问题
-bash-3.00# ls -l /home/db2data
total 0
drwxrwxr-x 3 db2inst1 db2grp1 256 Nov 04 18:45 db2inst1
drwxr-xr-x 2 db2inst1 db2grp1 256 Nov 02 02:16 lost+found
db2diag.log
2007-11-13-17.05.33.834658-360 I1A1194 LEVEL: Event
PID : 307360 TID : 1 PROC : db2agent (TEST) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120
START : New Diagnostic Log file
DATA #1 : Build Level, 152 bytes
Instance "db2inst1" uses "64" bits and DB2 code release "SQL09010"
with level identifier "02010107".
Informational tokens are "DB2 v9.1.0.0", "s060629", "AIX64", Fix Pack "0".
DATA #2 : System Info, 224 bytes
System: AIX srvibm004 3 5 0001F090D700
CPU: total:4 online:4 Threading degree per core:2
Physical Memory(MB): total:1904 free:1207
Virtual Memory(MB): total:2416 free:1715
Swap Memory(MB): total:512 free:508
Kernel Params: msgMaxMessageSize:4194304 msgMaxQueueSize:4194304
shmMax:68719476736 shmMin:1 shmIDs:131072
shmSegments:68719476736 semIDs:131072 semNumPerID:65535
semOps:1024 semMaxVal:32767 semAdjustOnExit:16384
Information in this record is only valid at the time when this file was
created (see this record's time stamp)
2007-11-13-17.05.33.820722-360 I1196A363 LEVEL: Warning
PID : 307360 TID : 1 PROC : db2agent (TEST) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2007-11-13-17.05.33.896902-360 I1560A443 LEVEL: Error
PID : 307360 TID : 1 PROC : db2agent (TEST) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDoContainerOp, probe:815
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
"Container not accessible"
2007-11-13-17.05.33.897100-360 I2004A482 LEVEL: Error
PID : 307360 TID : 1 PROC : db2agent (TEST) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDoContainerOp, probe:815
DATA #1 : String, 114 bytes
Error checking container 0 (/home/db2data/db2inst1/NODE0000/TEST/T0000001/C0000000.TMP) for tbsp 1. Rc = 860F000A
2007-11-13-17.05.33.897248-360 I2487A439 LEVEL: Error
PID : 307360 TID : 1 PROC : db2agent (TEST) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSStartPool, probe:105
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
"Container not accessible"
2007-11-13-17.05.33.897398-360 E2927A514 LEVEL: Error
PID : 307360 TID : 1 PROC : db2agent (TEST) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:30
MESSAGE : ADM6023I The table space "TEMPSPACE1" (ID "1") is in state 0x"0".
The table space cannot be accessed. Refer to the documentation for
SQLCODE -290.
2007-11-13-17.05.33.897611-360 I3442A436 LEVEL: Error
PID : 307360 TID : 1 PROC : db2agent (TEST) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:30
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
"Container not accessible"
2007-11-13-17.05.33.897759-360 E3879A528 LEVEL: Severe
PID : 307360 TID : 1 PROC : db2agent (TEST) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPoolsErrorHandling, probe:55
MESSAGE : ADM6023I The table space "TEMPSPACE1" (ID "1") is in state 0x"0".
The table space cannot be accessed. Refer to the documentation for
SQLCODE -290.
2007-11-13-17.05.33.901599-360 E4408A1274 LEVEL: Error
PID : 307360 TID : 1 PROC : db2agent (TEST) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:63
MESSAGE : ADM6049E The database cannot be restarted because one or more table
spaces cannot be brought online. To restart the database specify the
"DROP PENDING TABLESPACES" option on the RESTART DATABASE command.
WARNING! PUTTING A TABLESPACE INTO THE DROP PENDING STATE MEANS THAT
NO FURTHER ACCESS TO THE TABLESPACE WILL BE ALLOWED. ITS CONTENTS
WILL BE INACCESSIBLE THROUGHOUT THE REMAINDER OF THE LIFE OF THE
TABLESPACE AND THE ONLY OPERATION THAT WILL BE ALLOWED ON IT IS "DROP
TABLESPACE". There is no way in which it can be brought back. It is
important that you consider the consequences of this action as data
can be lost as a result. Before proceeding consult the DB2
documentation and contact IBM support if necessary. The table spaces
to specify in the DROP PENDING TABLESPACES list are: "TEMPSPACE1 ".
2007-11-13-17.05.33.901832-360 I5683A452 LEVEL: Error
PID : 307360 TID : 1 PROC : db2agent (TEST) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:182
MESSAGE : ZRC=0x80020035=-2147352523=SQLB_NOT_ALLOWED_RECOVERY_P
"Access not allowed. Tblspc Recovery Pend."
2007-11-13-17.05.33.901979-360 I6136A446 LEVEL: Error
PID : 307360 TID : 1 PROC : db2agent (TEST) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:590
MESSAGE : ZRC=0x80020035=-2147352523=SQLB_NOT_ALLOWED_RECOVERY_P
"Access not allowed. Tblspc Recovery Pend."
2007-11-13-17.05.33.904948-360 I6583A422 LEVEL: Severe
PID : 307360 TID : 1 PROC : db2agent (TEST) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:160
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFEABE0 : 8002 0035 ...5
2007-11-13-17.05.33.905108-360 I7006A421 LEVEL: Error
PID : 307360 TID : 1 PROC : db2agent (TEST) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:160
DATA #2 : Hexdump, 4 bytes
0x0FFFFFFFFFFEABE0 : 8002 0035 ...5
2007-11-13-17.05.33.905226-360 I7428A430 LEVEL: Severe
PID : 307360 TID : 1 PROC : db2agent (TEST) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:100
DATA #1 : Hexdump, 4 bytes
0x0000000110D1326C : FFFF FEDE ....
2007-11-13-17.05.33.906226-360 I7859A471 LEVEL: Severe
PID : 307360 TID : 1 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-25 APPID: *LOCAL.db2inst1.071113230533
AUTHID : DB2INST1
FUNCTION: DB2 UDB, base sys utilities, sqlescln, probe:24
DATA #1 : String, 22 bytes
sqlm_d_exit is failed.
DATA #2 : Hexdump, 4 bytes
0x0FFFFFFFFFFEA4C0 : 0000 0001 .... |
|