If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DIA3727C The database has been marked as being damaged.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-17-03, 00:51
jagan_5378 jagan_5378 is offline
Registered User
 
Join Date: Nov 2003
Posts: 68
DIA3727C The database has been marked as being damaged.

hi to all
we are using db2 7.2 on linux 6.2
pl tell me y this error is comming
some times database automatically disconnected.

2003-12-17-10.16.58.127106 Instance:db2inst1 Node:000
PID:3759(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217044636
base_sys_utilities sqledbcu Probe:33 Database:TESTKALA

Number of local applications forced: 1200 0000 ....



2003-12-17-10.16.58.166148 Instance:db2inst1 Node:000
PID:1085(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217042823
buffer_pool_services sqlbTerminateAgent Probe:837 Database:TESTKALA
DIA3727C The database has been marked as being damaged.

ZRC=0xFFFFE11A

2003-12-17-10.16.58.167736 Instance:db2inst1 Node:000
PID:1085(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217042823
base_sys_utilities sqleTermDbConnect Probe:5 Database:TESTKALA
DIA3727C The database has been marked as being damaged.

ZRC=0xFFFFE11A

2003-12-17-10.17.11.866300 Instance:db2inst1 Node:000
PID:3754(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217044711
Reply With Quote
  #2 (permalink)  
Old 12-17-03, 03:43
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
Re: DIA3727C The database has been marked as being damaged.

Shut down the database and use the db2dart tool to check the integrity of the database

Cheers
Sathyaram

Quote:
Originally posted by jagan_5378
hi to all
we are using db2 7.2 on linux 6.2
pl tell me y this error is comming
some times database automatically disconnected.

2003-12-17-10.16.58.127106 Instance:db2inst1 Node:000
PID:3759(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217044636
base_sys_utilities sqledbcu Probe:33 Database:TESTKALA

Number of local applications forced: 1200 0000 ....



2003-12-17-10.16.58.166148 Instance:db2inst1 Node:000
PID:1085(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217042823
buffer_pool_services sqlbTerminateAgent Probe:837 Database:TESTKALA
DIA3727C The database has been marked as being damaged.

ZRC=0xFFFFE11A

2003-12-17-10.16.58.167736 Instance:db2inst1 Node:000
PID:1085(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217042823
base_sys_utilities sqleTermDbConnect Probe:5 Database:TESTKALA
DIA3727C The database has been marked as being damaged.

ZRC=0xFFFFE11A

2003-12-17-10.17.11.866300 Instance:db2inst1 Node:000
PID:3754(db2agent (TESTKALA)) Appid:*LOCAL.db2inst1.031217044711
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #3 (permalink)  
Old 12-17-03, 07:36
jagan_5378 jagan_5378 is offline
Registered User
 
Join Date: Nov 2003
Posts: 68
thank u for u r immidate reply.
i done above step.
next what i have to do
Data inspection phase end.

Table inspection end.

Tablespace inspection phase end.


Tablespace inspection phase start. Pool: 3
This is a temporary table space. Nothing to inspect.
Tablespace inspection phase end.

Database inspection phase end.

______________________________________

DB2DART Processing completed with warning(s)!
Warning(s) detected during processing.
______________________________________

Complete DB2DART report found in: TESTKALA.RPT

_______ D A R T P R O C E S S I N G C O M P L E T E ___

TESTKALA.RPT file data
Action option: DB

Warning: The database state is not consistent.
Connecting to Buffer Pool Services...

Database inspection phase start.

Tablespace file inspection phase start.
Loading tablespace files.
Inspecting next tablespace and associated containers.
Inspecting next tablespace and associated containers.
Inspecting next tablespace and associated containers.
Inspecting next tablespace and associated containers.
4 tablespaces were identified and their containers checked.
Tablespace file inspection phase end.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On