Hi List ..
I am using DB2 UDB V 7.2 On Linux V 7.2
Today i restored one DB named j2eeofsy From one of my backup image which
i created using (db2 backup db j2eeofsy ).
while restoring i issued command
restore db j2eeofsy
..
Now every thing is working fine ... except ..
when ever i try to create any table or drop any table i get a error
message :
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0902C A system error (reason code = "9") occurred. Subsequent SQL
statements cannot be processed. SQLSTATE=58005
and instance dies ..... (i have reissue db2start to access the tables .. )
it states that turn the trace .. but i a mnot able to as db2 crashes
when ever i try to create a table ... so trace also dies ..
This is the part of db2diag.log file ....
Data Title:section stmt PID:29528 Node:000
6372 6561 7465 2074 6162 6c65 2074 7020 create table tp
2820 6964 2063 6861 7228 3130 2929 ( id char(10))
Dump File:/home/db2inst1/sqllib/db2dump/29528.000 Data:section stmt
2003-04-19-16.28.08.844032 Instance:db2inst1 Node:000
PID:29528(db2agent (J2EEOFSY)) Appid:*LOCAL.db2inst1.030419105644
relation_data_serv sqlrr_signal_handler Probe:20 Database:J2EEOFSY
DIA7108I Execution of a component signal handling function is complete.
2003-04-19-16.28.08.845497 Instance:db2inst1 Node:000
PID:29528(db2agent (J2EEOFSY)) Appid:*LOCAL.db2inst1.030419105644
buffer_pool_services sqlbReadPage Probe:71 Database:J2EEOFSY
** Failure on first attempt to read the page ** 09f6
ffff .öÿÿ
2003-04-19-16.28.08.849806 Instance:db2inst1 Node:000
PID:29528(db2agent (J2EEOFSY)) Appid:*LOCAL.db2inst1.030419105644
buffer_pool_services sqlbrdpg Probe:1110 Database:J2EEOFSY
DIA3806C Unexpected end of file was reached.
ZRC=0xFFFFF609
2003-04-19-16.28.08.853540 Instance:db2inst1 Node:000
PID:29528(db2agent (J2EEOFSY)) Appid:*LOCAL.db2inst1.030419105644
buffer_pool_services sqlbrdpg Probe:1110 Database:J2EEOFSY
Obj={pool:0;obj:3;type:1} State=x27 Page=895 Cont=0 Offset=895 BlkSize=12
Unexpected EOF
Can any one help me out ... what's the problem ...
i have 3 buffer pools for with DB ..
db2 => select * From syscat.bufferpools
BPNAME BUFFERPOOLID NGNAME NPAGES
PAGESIZE ESTORE
------------------ ------------ ------------------ -----------
----------- ------
IBMDEFAULTBP 1 - 1000 4096 N
BP3 2 - 2000 8192 N
BP4 3 - 5000 4096 N
Regards
Yogesh
Yogesh Kansal
Davlin Software Pvt Ltd .
2nd Floor , Punja Building,
Lalbaugh , Mangalore
Ph 0824-451001 ext - 19
"For every problem there is always a solution that is simple, obvious, and wrong !! "
DB2 & UDB email list listserv db2-l LazyDBA home page