Skip to Content
0
Former Member
May 13, 2011 at 06:52 AM

DB2 backup fails

60 Views

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