|
|
原帖由 unixnewbie 于 2008-9-24 12:17 发表 ![]()
1. RESTART DATABASE DROP PENDING TABLESPACES
2. drop tablespace MPSYS2
3. drop tablespace TMPUSR1
4. if there were data on those tablespaces, restore them from backup image and rollforward toend of logs.
还是不行啊，还报那个错误。。。
db2 restart database sample drop pending tablespaces(tmpsys2,tmpuser1)
SQL0290N 不允许访问表空间。 SQLSTATE=55039
最新的db2diag。log日志，操所了上面的语句后
2008-09-25-13.58.04.515000+480 E299732774H1371 LEVEL: Error
PID : 2444 TID : 188 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-65 APPID: *LOCAL.DB2.080925055705
AUTHID : ADMINISTRATOR
EDUID : 188 EDUNAME: db2agent (sample) 0
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: "TMPUSR1 ".
2008-09-25-13.58.04.515000+480 I299734147H542 LEVEL: Error
PID : 2444 TID : 188 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-65 APPID: *LOCAL.DB2.080925055705
AUTHID : ADMINISTRATOR
EDUID : 188 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:182
MESSAGE : ZRC=0x80020035=-2147352523=SQLB_NOT_ALLOWED_RECOVERY_P
"Access not allowed. Tblspc Recovery Pend."
2008-09-25-13.58.04.515000+480 I299734691H536 LEVEL: Error
PID : 2444 TID : 188 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-65 APPID: *LOCAL.DB2.080925055705
AUTHID : ADMINISTRATOR
EDUID : 188 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:590
MESSAGE : ZRC=0x80020035=-2147352523=SQLB_NOT_ALLOWED_RECOVERY_P
"Access not allowed. Tblspc Recovery Pend."
2008-09-25-13.58.04.562000+480 I299735229H504 LEVEL: Severe
PID : 2444 TID : 188 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-65 APPID: *LOCAL.DB2.080925055705
AUTHID : ADMINISTRATOR
EDUID : 188 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:160
DATA #1 : Hexdump, 4 bytes
0x02EC2B54 : 3500 0280 5...
2008-09-25-13.58.04.562000+480 I299735735H503 LEVEL: Error
PID : 2444 TID : 188 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-65 APPID: *LOCAL.DB2.080925055705
AUTHID : ADMINISTRATOR
EDUID : 188 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:160
DATA #2 : Hexdump, 4 bytes
0x02EC2B54 : 3500 0280 5...
2008-09-25-13.58.04.562000+480 I299736240H526 LEVEL: Severe
PID : 2444 TID : 188 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-65 APPID: *LOCAL.DB2.080925055705
AUTHID : ADMINISTRATOR
EDUID : 188 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
DATA #1 : Hexdump, 4 bytes
0x7E1CE598 : DEFE FFFF ....
2008-09-25-13.58.11.671000+480 I299736768H455 LEVEL: Warning
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.
2008-09-25-13.58.12.093000+480 I299737225H466 LEVEL: Error
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartUsingFile, probe:805
MESSAGE : ZRC=0x83000570=-2097150608
2008-09-25-13.58.12.093000+480 I299737693H465 LEVEL: Error
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartUsingDir, probe:810
MESSAGE : ZRC=0x83000570=-2097150608
2008-09-25-13.58.12.093000+480 I299738160H513 LEVEL: Error
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartUsingDir, probe:810
DATA #1 : String, 56 bytes
Error processing file y:\DB2DATA\rtmpsys02\SQL00020.TDA.
2008-09-25-13.58.12.093000+480 I299738675H464 LEVEL: Error
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSStartPool, probe:110
MESSAGE : ZRC=0x83000570=-2097150608
2008-09-25-13.58.12.093000+480 E299739141H604 LEVEL: Info
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:30
MESSAGE : ADM6023I The table space "TMPSYS2" (ID "8") is in state 0x"0". The
table space cannot be accessed. Refer to the documentation for
SQLCODE -290.
2008-09-25-13.58.12.093000+480 I299739747H461 LEVEL: Error
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:30
MESSAGE : ZRC=0x83000570=-2097150608
2008-09-25-13.58.12.093000+480 E299740210H617 LEVEL: Info
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPoolsErrorHandling, probe:55
MESSAGE : ADM6023I The table space "TMPSYS2" (ID "8") is in state 0x"0". The
table space cannot be accessed. Refer to the documentation for
SQLCODE -290.
2008-09-25-13.58.12.093000+480 I299740829H466 LEVEL: Error
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartUsingFile, probe:800
MESSAGE : ZRC=0x83000570=-2097150608
2008-09-25-13.58.12.093000+480 I299741297H465 LEVEL: Error
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartUsingDir, probe:810
MESSAGE : ZRC=0x83000570=-2097150608
2008-09-25-13.58.12.093000+480 I299741764H513 LEVEL: Error
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartUsingDir, probe:810
DATA #1 : String, 56 bytes
Error processing file y:\DB2DATA\rtmpusr01\SQL00003.TDA.
2008-09-25-13.58.12.093000+480 I299742279H464 LEVEL: Error
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSStartPool, probe:110
MESSAGE : ZRC=0x83000570=-2097150608
2008-09-25-13.58.12.093000+480 E299742745H604 LEVEL: Info
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:30
MESSAGE : ADM6023I The table space "TMPUSR1" (ID "9") is in state 0x"0". The
table space cannot be accessed. Refer to the documentation for
SQLCODE -290.
2008-09-25-13.58.12.093000+480 I299743351H461 LEVEL: Error
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:30
MESSAGE : ZRC=0x83000570=-2097150608
2008-09-25-13.58.12.093000+480 E299743814H617 LEVEL: Info
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPoolsErrorHandling, probe:55
MESSAGE : ADM6023I The table space "TMPUSR1" (ID "9") is in state 0x"0". The
table space cannot be accessed. Refer to the documentation for
SQLCODE -290.
2008-09-25-13.58.12.890000+480 E299744433H1394 LEVEL: Error
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
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: "TMPSYS2 TMPUSR1
".
2008-09-25-13.58.12.890000+480 I299745829H545 LEVEL: Error
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:182
MESSAGE : ZRC=0x80020035=-2147352523=SQLB_NOT_ALLOWED_RECOVERY_P
"Access not allowed. Tblspc Recovery Pend."
2008-09-25-13.58.12.890000+480 I299746376H539 LEVEL: Error
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:590
MESSAGE : ZRC=0x80020035=-2147352523=SQLB_NOT_ALLOWED_RECOVERY_P
"Access not allowed. Tblspc Recovery Pend."
2008-09-25-13.58.12.937000+480 I299746917H507 LEVEL: Severe
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:160
DATA #1 : Hexdump, 4 bytes
0x02C83954 : 3500 0280 5...
2008-09-25-13.58.12.937000+480 I299747426H506 LEVEL: Error
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:160
DATA #2 : Hexdump, 4 bytes
0x02C83954 : 3500 0280 5...
2008-09-25-13.58.12.937000+480 I299747934H529 LEVEL: Severe
PID : 2444 TID : 684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : sample
APPHDL : 0-39 APPID: 10.45.24.22.39684.080925055354
AUTHID : LNGA_QB
EDUID : 684 EDUNAME: db2agent (sample) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
DATA #1 : Hexdump, 4 bytes
0x7E1C4428 : DEFE FFFF |
|
楼主: 桤木卡卡西
IP卡
狗仔卡
发表于 2008-9-25 12:17
显身卡
楼主
发表于 2013-11-7 17:51