473,320 Members | 1,744 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Backup Failure - 4 node DPF Setup One node is down

When i made one Node ( node number 2 non catalog node ) down and taking backups by giving rest of the partitionnums backup are failing intermittently
following it the db2diag content i am getting inresponse of failure.


2011-11-28-16.11.41.193133+330 E419091E511 LEVEL: Error\par
PID : 12485 TID : 47804865046848PROC : db2sysc 0\par
INSTANCE: db2inst1 NODE : 000 DB : AVAMAR1\par
APPHDL : 0-477 APPID: *N0.db2inst1.111128104139\par
AUTHID : DB2INST1\par
EDUID : 2803 EDUNAME: db2agent (AVAMAR1) 0\par
FUNCTION: DB2 UDB, database utilities, sqlubkdReceiveReply, probe:999\par
MESSAGE : ZRC=0x81580016=-2124939242=SQLKD_NODE_FAILURE\par
"Mapping for SQLKF_NODE_FAILED"\par
\par
2011-11-28-16.11.41.193275+330 E419603E509 LEVEL: Error\par
PID : 12485 TID : 47804865046848PROC : db2sysc 0\par
INSTANCE: db2inst1 NODE : 000 DB : AVAMAR1\par
APPHDL : 0-477 APPID: *N0.db2inst1.111128104139\par
AUTHID : DB2INST1\par
EDUID : 2803 EDUNAME: db2agent (AVAMAR1) 0\par
FUNCTION: DB2 UDB, database utilities, sqlubMPPRequestor, probe:583\par
MESSAGE : ZRC=0x81580016=-2124939242=SQLKD_NODE_FAILURE\par
"Mapping for SQLKF_NODE_FAILED"\par
\par
2011-11-28-16.11.41.193348+330 E420113E522 LEVEL: Error\par
PID : 12485 TID : 47804865046848PROC : db2sysc 0\par
INSTANCE: db2inst1 NODE : 000 DB : AVAMAR1\par
APPHDL : 0-477 APPID: *N0.db2inst1.111128104139\par
AUTHID : DB2INST1\par
EDUID : 2803 EDUNAME: db2agent (AVAMAR1) 0\par
FUNCTION: DB2 UDB, database utilities, sqlubMPPRequestor, probe:1184\par
MESSAGE : SQL1170N The operation cannot continue because database partition\par
"2" is not available.\par


It seems DB2 trying to connect to node number 2 also although i didn't give the nodenumber 2 while firing the backup.
As it's happening intermittently Please let me know what can be the cause for this.
Dec 1 '11 #1
1 3256
Please find the proper presentation of the problem, as follows :

We are supporting IBM DB2 9.5, and 9.7 in our backup software.

We are having the following DB2 setup:

OS: Red Hat Enterprise Linux 5 x86_64

DB2: DB2 v9.5.0.0

We have configured a DPF setup with two hosts, total 4 database partitions
- 0,1,2 and 3.

Node 0 is the catalog node.

Host 1 is having partitions 0 and 1
Host 2 is having partitions 2 and 3

We have 1 database - AVAMAR1

We have brought down partition 3 using - db2stop NODENUM 3.

After this we tried to take ONLINE backup of remaining partitions 0,1 and 2 of AVAMAR1 database from command line.

db2 'backup db AVAMAR1 on all dbpartitionnums except dbpartitionnum (3) online to /tmp'

I tried the same with following command also:

db2 'backup db AVAMAR1 on dbpartitionnum(0,1,2) online to /tmp';

We observed that backup failed for AVAMAR1 and observed the many errors in db2diag.log

However, the below error is of particular interest to us:

MESSAGE : SQL1170N The operation cannot continue because database partition
"3" is not available.

It seems DB2 is trying to connect to partition number 3, although we didn't give the partition 3 while firing the backup.


Could you please point to what might be going wrong here.

We are observing the same behavior with DB2 9.7 on RHEL 5 x86_64 as well.

N.B. : LOGRETAIN is ON for this database , and offline backup is already taken on all the partitions.
Dec 5 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: tim groulx | last post by:
I have recently started receiving failures on a differential backup that previously succeeded. Nothing has changed with the structure of the db. Here is the message, any ideas are welcomed. Thanks....
2
by: nt | last post by:
I am having a problem with a regular backup of an SQL Server (MSDE 2000) database to a local drive. I initiate the backup once a week, by issuing the required T-SQL, via ADO. In this case, the...
1
by: Stephanie | last post by:
I have not been able to find any details about backup failures for MSSQL 2000. I am researching the following: 1. when a backup fails at a certain point during the process does the backup: A....
1
by: Omkar Singh | last post by:
I have want to read a xml file node by node. How can I do it? I am using following code to load xml file. XmlDocument doc = new XmlDocument(); doc.Load(fileName);
3
by: Dinesh_GR | last post by:
Hi all, I have many parent tags and many child tags under the respective parent.. in an XML file. On the click of a button the application should pick up the one parent and the corresponding...
1
by: cat | last post by:
Hi, One of our database delta backup keep failing for about 2 weeks. Is there anyone has the same experience, when DB2 do the delta backup, will it lock recovery history file and how you monitor...
3
by: Ben | last post by:
Hi, Can anyone tell me how to move a node up or down in an xml document? For example: <root> <field name="1"/> <field name="2"/> <field name="3"/> </root>
1
by: David Greenberg | last post by:
Hi My DB backup and transaction backup of a database keep on failing with the following error: Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: Write on...
3
by: alhalayqa | last post by:
hi guys, how can distinguish between XML Node and HTML Node, using attributes or method .. thanks .
4
by: Christiano Donke | last post by:
Hey there... I intend to make a WindowsApp menu like... For that I need to read a XML file node by node to try to create (at runtime) the items... Where can I find some clear information on...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.