I am sorry to say that all of the documentation that I have says to capture a trace
of the command, gather all of the results, the logs, and the offending commands,
and send them to IBM. You have caused in internal error in the databaes.

Wish I had more. I have been in a similar instance and was left high and dry.
However, once I got IBM the information, and response was quick. If you do
get a trick from IBM in the response, send it to the list. In my case, the problem
was eventually traced to a bad RAID controller.

Richard Reppert


On Sat, 19 Apr 2003 17:40:58 +0530, yogesh kansal wrote:

>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 !! "
>
>
>
>
>
>
>---------------------------------------------------------------------
>PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed] J Reppert
Sumx Inc.
972-355-8004 x102
972-355-8048 fax


DB2 & UDB email list listserv db2-l LazyDBA home page