javier2004
Programmer
The database has been working perfectly all these years. But suddenly today while one user was making a query, the database could not be accessed.
The database is installed on a Windows NT 4.0, Service Pack 6.
I opened the Control Center, I could see the database, however when I try to connect or to make a click on "Tables", "Views", "Tablespaces",.... I got the next message:
"ERROR ACCESSING A TABLESPACE CONTAINER. SQLSTATE: 57048."
The same happens when I try to connect through the command window manually. Here I could neither to make a db2 restart nor db2 rollforward nor connect.
I read the db2diag.log , and found this:
2004-11-26-18.35.49.937000 InstanceB2 Node:000
PID:102(db2syscs.exe) TID:186 Appid:C0A80A10.E804.041126233548
buffer_pool_services sqlbDMSDoContainerOp Probe:840 Database:COMERCIO
DIA9999E An internal error occurred. Report the following error code :
"FFFFC11E".
2004-11-26-18.35.49.953000 InstanceB2 Node:000
PID:102(db2syscs.exe) TID:186 Appid:C0A80A10.E804.041126233548
buffer_pool_services sqlbDMSDoContainerOp Probe:840 Database:COMERCIO
Error checking container 0 (E:\Indices\INDICES1) for tbsp 0. Rc = FFFFC11E
Data Title:SQLB_CONTAINER_TAG PID:102 TID:186 Node:000
4000 8002 68b5 c102 f471 ca03 efed 0210 @.€.hµÁ.ôqÊ.ïí..
4000 8002 880d d701 0040 7f02 4000 8002
........more lines here......
the Database has a tablespace for data, other tablespace for CATALOG, and other for Temporal.
When I created the tablespaces for data,catalog and temporal, I selected dms (database managed). I allocated 3000 mb in the file Indices1 for the CATALOG TABLESPACE. but i Found it with 0 bytes?????
What can i do to correct this error and to avoid it in the future.
Help me please.
tHANK YOU IN ADVANCE.
The database is installed on a Windows NT 4.0, Service Pack 6.
I opened the Control Center, I could see the database, however when I try to connect or to make a click on "Tables", "Views", "Tablespaces",.... I got the next message:
"ERROR ACCESSING A TABLESPACE CONTAINER. SQLSTATE: 57048."
The same happens when I try to connect through the command window manually. Here I could neither to make a db2 restart nor db2 rollforward nor connect.
I read the db2diag.log , and found this:
2004-11-26-18.35.49.937000 InstanceB2 Node:000
PID:102(db2syscs.exe) TID:186 Appid:C0A80A10.E804.041126233548
buffer_pool_services sqlbDMSDoContainerOp Probe:840 Database:COMERCIO
DIA9999E An internal error occurred. Report the following error code :
"FFFFC11E".
2004-11-26-18.35.49.953000 InstanceB2 Node:000
PID:102(db2syscs.exe) TID:186 Appid:C0A80A10.E804.041126233548
buffer_pool_services sqlbDMSDoContainerOp Probe:840 Database:COMERCIO
Error checking container 0 (E:\Indices\INDICES1) for tbsp 0. Rc = FFFFC11E
Data Title:SQLB_CONTAINER_TAG PID:102 TID:186 Node:000
4000 8002 68b5 c102 f471 ca03 efed 0210 @.€.hµÁ.ôqÊ.ïí..
4000 8002 880d d701 0040 7f02 4000 8002
........more lines here......
the Database has a tablespace for data, other tablespace for CATALOG, and other for Temporal.
When I created the tablespaces for data,catalog and temporal, I selected dms (database managed). I allocated 3000 mb in the file Indices1 for the CATALOG TABLESPACE. but i Found it with 0 bytes?????
What can i do to correct this error and to avoid it in the future.
Help me please.
tHANK YOU IN ADVANCE.