Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE
Highlighted
Established Member.. shababmk
Established Member..
846 views

DB2 Archive Log issue DP 8.1

Hi Folks,

 

I am facing the below issue,

 

The Archive log backups (for DB2) is running fine until the message "
[Normal] From: BMA@ignite "HP:Ultrium 6-SCSI_1_ignite_bk" Time: 10/8/2014 6:03:59 PM
COMPLETED Media Agent "HP:Ultrium 6-SCSI_1_ignite_bk"" and it hangs there.

 

When there is new archive logs are flushed out from DB2 side, DP loads the medium and backup it again, but the session remains open. It never ends.

 

I have attached the full session report. 

 

I would really badly need help from DP gurus. 

 

Thanks a milllion in advance. 

 

 

DP version : 8.1 with all the latest patches running HP-UX.11.31

DB2 version : 10.5 with latest patches running on HP-UX 11.31

 

==================================

Session report

==================================

 

[Normal] From: BSM@ignite "STP_Archive_log" Time: 10/8/2014 5:51:13 PM
Backup session 2014/10/08-20 started.

[Normal] From: BMA@ignite "HP:Ultrium 6-SCSI_1_ignite_bk" Time: 10/8/2014 5:51:14 PM
STARTING Media Agent "HP:Ultrium 6-SCSI_1_ignite_bk"

[Normal] From: BMA@ignite "HP:Ultrium 6-SCSI_1_ignite_bk" Time: 10/8/2014 5:51:15 PM
=> UMA@ignite@/dev/rchgr/autoch1
Loading medium from slot 25 to device /dev/rtape/tape7_BESTn

[Normal] From: OB2BAR_DB2ARCH@jade "db2stp" Time: 10/8/2014 5:50:14 PM
Starting OB2BAR Backup: jade:db2stp:STP:0:0:0 "DB2"

[Warning] From: BMA@ignite "HP:Ultrium 6-SCSI_1_ignite_bk" Time: 10/8/2014 5:52:31 PM
[90:195] Physical position of the last segment is not consistent with the
position information from the database. Instead of expected last
segment number 18, last segment on the tape is 28.

[Normal] From: OB2BAR_DB2ARCH@jade "db2stp" Time: 10/8/2014 5:50:34 PM
Backup Profile:

Run Time ........... 0:00:20
Backup Speed ....... 1.90 MB/s

[Normal] From: OB2BAR_DB2ARCH@jade "db2stp" Time: 10/8/2014 5:50:34 PM
Completed OB2BAR Backup: jade:db2stp:STP:0:0:0 "DB2"

[Normal] From: OB2BAR_DB2ARCH@jade "db2stp" Time: 10/8/2014 5:50:34 PM
File /db2/STP/log_dir/NODE0000/LOGSTREAM0000/S0000501.LOG backed up successfully

[Normal] From: BMA@ignite "HP:Ultrium 6-SCSI_1_ignite_bk" Time: 10/8/2014 6:03:05 PM
/dev/rtape/tape7_BESTn
Medium header verification completed, 0 errors found.

[Normal] From: BMA@ignite "HP:Ultrium 6-SCSI_1_ignite_bk" Time: 10/8/2014 6:03:23 PM
Ejecting medium '25'.

[Normal] From: BMA@ignite "HP:Ultrium 6-SCSI_1_ignite_bk" Time: 10/8/2014 6:03:23 PM
=> UMA@ignite@/dev/rchgr/autoch1
Unloading medium to slot 25 from device /dev/rtape/tape7_BESTn

[Normal] From: BMA@ignite "HP:Ultrium 6-SCSI_1_ignite_bk" Time: 10/8/2014 6:03:59 PM
COMPLETED Media Agent "HP:Ultrium 6-SCSI_1_ignite_bk"

 ==============================================================

 

 

Regards,

Sha.

Tags (1)
0 Likes
2 Replies
Bob_Clark Absent Member.
Absent Member.

Re: DB2 Archive Log issue DP 8.1

I would recommend that you implement KeepAlive on the DB2 server. I have seen similiar symptoms quite a lot

 

Since you did not include teh Server type you are running DB2 on, I can't give specific instructions

0 Likes
Bob_Clark Absent Member.
Absent Member.

Re: DB2 Archive Log issue DP 8.1

oops, you did... sorry, I missed it the first time

 

I have attached the KeepAlive procedure

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.