cancel
Showing results for 
Search instead for 
Did you mean: 

error in db2 offline backup

Former Member
0 Kudos

hi

I changed the password of db2<sid> and <sid>adm in windows manage users, now the backup is getting failed.

it showing the following error :

Job started

Step 001 started (program RSDBAJOB, variant &0000000000446, user ID BASIS)

Execute logical command DB6_DBBACKUP On host sapprd

Parameters:TRP OFFLINE TO E:\BACKUP BUFFERS 0 BUFFERSIZE 0 PARALLELISM 0

ERRORMESSAGE: Error -30082 in dmdb6bkp.c(1866):

sqleatin() returned SQLCODE -30082. . SQL30082N  Attempt to establish

connection failed with security reason "24"

("USERNAME AND/OR

PASSWORD INVALID").  SQLSTATE=08001

External program terminated with exit code 2

DB6_DBBACKUP returned error status E

Job finished

please suggest

regards

yuvi

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Yuvraj,

Did you change the password using dscdb6up command?

If not please use below command to change/reset it again and let us know the result.

dscdb6up <userId> <password>

This will change the password for database and operating system's user too.

Post steup Reflect the same in DBACOCKPIT, and test connection.

Regards,

Prithviraj.