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 > DB2 non-partition Node Crash

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-16-04, 10:48
kgunnam kgunnam is offline
Registered User
 
Join Date: Jan 2004
Location: Reston, VA
Posts: 4
Post DB2 non-partition Node Crash

DB2 V7.2 Fixpak 10a + Special Build ( for Write Suspend) on aix 4.3.3

We had a non-partition node crash couple of days back and i am just wondering had any idea. Ofcourse we are working on with IBM. Here are the facts

1. A Sql run by one of our developer had current node coded. Which when it went aganist node 17 ( non partioned node) its crashing the node.

2. As far as me it should give a message that it is not partitioned.

3. Node 17 acts as node for code tables and co-ordinator node and some clients.

Here is the daiag.log output

004-01-14-10.06.41.827081 Instance:udbcdwp Node:017
PID:54824(db2agent (DR_CDWP) 17) Appid:AC1845F5.0656.040114131647
relation_data_serv sqlrr_signal_handler Probe:10 Database:CDWP
DIA7107I Execution of a component signal handling function has begun.

Data Title:section stmt PID:54824 Node:017
7365 6c65 6374 2067 2e6e 6272 5f6d 7274 select g.nbr_mrt
6720 6173 206e 6272 5f6d 7274 672c 2067 g as nbr_mrtg, g
2e61 6d74 5f75 7062 5f75 6e66 6163 7472 .amt_upb_unfactr
6420 6173 2061 6d74 5f75 7062 5f75 6e66 d as amt_upb_unf
6163 7472 642c 2067 2e72 6174 655f 6e6f actrd, g.rate_no
7465 2061 7320 7261 7465 5f6e 6f74 6520 te as rate_note
6672 6f6d 2075 6462 6164 6d2e 745f 6d72 from udbadm.t_mr
7467 5f70 796d 745f 6873 7420 672c 2075 tg_pymt_hst g, u
6462 6164 6d2e 7262 635f 7375 626d 6e5f dbadm.rbc_submn_
6361 6c20 6820 7768 6572 6520 682e 6964 cal h where h.id
5f73 7562 6d6e 203d 2031 2061 6e64 2079 _submn = 1 and y
....
274d 4627 2920 616e 6420 6e6f 6465 6e75 'MF') and nodenu
6d62 6572 2867 2e6e 6272 5f6d 7274 6729 mber(g.nbr_mrtg)

2004-01-14-10.06.59.369949 Instance:udbcdwp Node:017
PID:56148(db2agent (DR_CDWP) 17) Appid:AC1825B7.0990.040114144944
buffer_pool_services sqlbTerminateAgent Probe:837 Database:CDWP
DIA3727C The database has been marked as being damaged.

ZRC=0xFFFFE11A

2004-01-14-10.07.04.268879 Instance:udbcdwp Node:017
PID:99018(db2agent (DR_CDWP) 17) Appid:*N17.udbcdwp.040114150657
base_sys_utilities sqledint Probe:0 Database:CDWP

Crash Recovery is needed.



ANY CLUES or IDEAS?????

Thanks
Kiran
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