DB2 backup fails

[Former Member]

Hi Experts,

Recently Quality refresh has been done, now I am scheduling online backup through DB13. But I am getting below error,

Job started

Step 001 started (program RSDBAJOB, variant &0000000001261, user ID BASISADM)

Execute logical command DB6_DBBACKUP On host GIL-devqas1

Parameters:PRD ONLINE TO /dev/rmt0 BUFFERS 0 BUFFERSIZE 0 PARALLELISM 0 INCLUDE LOGS

Job started

Step 001 started (program RSDBAJOB, variant &0000000001277, user ID BASISADM)

Execute logical command DB6_DBBACKUP On host GIL-devqas1

Parameters:QAS ONLINE TO /dev/rmt0 BUFFERS 0 BUFFERSIZE 0 PARALLELISM 0 INCLUDE LOGS

set connect partition: 0

Making database backup...

Database = PRD

Backup Mode = FULL

Backup Options= ONLINE

+ INCLUDE LOGS

Buffer size = AUTOMATIC

1. buffers = AUTOMATIC*

Parallelism = AUTOMATIC

numLocations = 1

location[0] = /dev/rmt0

util priority = 0

ERRORMESSAGE: Error -1013 in dmdb6bkp.c(1498):

SQL1013N The database alias name or database name "PRD" could not be

found.

External program terminated with exit code 2

DB6_DBBACKUP returned error status E

Job finished

set connect partition: 0

Making database backup...

Database = QAS

Backup Mode = FULL

Backup Options= ONLINE

+ INCLUDE LOGS

Buffer size = AUTOMATIC

1. buffers = AUTOMATIC*

Parallelism = AUTOMATIC

numLocations = 1

location[0] = /dev/rmt0

util priority = 0

ERRORMESSAGE: Error -901 in dmdb6bkp.c(1498):

SQL1013N The database alias name or database name "PRD" could not be found

Even db2diag.log file not contains any message, it is showing 1KB. As per this error message it is searching for PRD database but it is QA server. Please help me how to resolve this issue.

Thanks and Regards,

Sampath Kumar.S

[Former Member]

Hi experts,

Thanks for your valuable suggestion and inputs. The issue is resolved by re-plug the tape drive in server and restarted the server again. And re-schedule the backup planning calendar in DB13.

Thanks & Regards,

Sampath.

[sunny_pahuja2]

Hi,

Could you please paste the output of below 2 commands:

db2 list db directory

db2 list node directory

Thanks

Sunny

[Former Member]

Hi sunny,

Please find the result for those query's below

1. db2 list db directory :

1. su - db2qas*

[YOU HAVE NEW MAIL]

GIL-devqas1:db2qas 1> db2 list db directory

System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database alias = QAS

Database name = QAS

Local database directory = /db2/QAS

Database release level = c.00

Comment =

Directory entry type = Indirect

Catalog database partition number = 0

Alternate server hostname =

Alternate server port number =

2. db2 list node directory :

GIL-devqas1:db2qas 6> db2 list node directory

SQL1027N The node directory cannot be found.

GIL-devqas1:db2qas 7>

Thanks & Regards,

Sampath

[Former Member]

Hello,

You sould check what instances are listed with 'db2ilist' command, as there may some default/test instance(s) installed...

to drop an instance you use the command

db2idrop

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.

ibm.db2.udb.doc/core/r0002058.htm

then db2icrt is used to create the instance again

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.

ibm.db2.udb.doc/start/t0006744.htm

After that, you should run db2iupt to update the instance.

See Note 1138549

Then check if the connection works, if so, you should be able to use DB13 successfully...

Regards,

Paul

Edited by: Paul Murtagh on May 18, 2011 3:01 AM