Warnings in db2diag.log for HADR configured db2 9.1 fp7 database after switchover over to DR site

[Former Member]

Hello Experts,

I have switched over to DR site and started SwAP and it is running even HADR status is in PEER status and sync happening between primary and DR site, but when i saw db2diag.log file entries via dbacockpit tcode it is showing warnings for each starting and archiving of a log file.

Started archive for log file S0000381.LOG

Completed archive for log file S0000381.LOG

Will it be any problem to database with this warnings.

Kindly suggest on the same.

Thanks,

Bharath.

[sunny_pahuja2]

Hello,

I don't see if these are warnings. It is telling you the status of HADR sync and which particular file is getting sync between primary and secondary.

Thanks,

Sunny

[Former Member]

Sunny,

Sorry i forgot to provide db2diag.log contents in the previous post. Please find it below

2014-01-25-18.16.47.320000+330 I1599100F377       LEVEL: Warning

PID     : 4604                 TID  : 5028        PROC : db2syscs.exe

INSTANCE: DB2TNT               NODE : 000

FUNCTION: DB2 UDB, data protection services, sqlpRenameStartUse, probe:1230

MESSAGE : Log file 381 is not added by DB2 because renameArray is full.File

          could be renamed while in use.

2014-01-25-18.16.47.320000+330 I1599479F377       LEVEL: Warning

PID     : 4604                 TID  : 5028        PROC : db2syscs.exe

INSTANCE: DB2TNT               NODE : 000

FUNCTION: DB2 UDB, data protection services, sqlpRenameStartUse, probe:1230

MESSAGE : Log file 381 is not added by DB2 because renameArray is full.File

          could be renamed while in use.

I have seen it will be resolved in fp11 of db2 9.1 as in link

http://www-01.ibm.com/support/docview.wss?uid=swg1IC75133

Kindly suggest the any other work around.

Thanks,

Bharath.

[sunny_pahuja2]

I checked link shared by you. It looks like bug in current fp. You can check the same with SAP Support as well.

Thanks,

Sunny

[Former Member]

I think you have implemented HADR on DB2 9.1 FP7.

Have you noticed any warnings in db2diag.log file?

Please suggest if have any information on this.

Thanks,

Bharath.

[sunny_pahuja2]

I am not sure what was the level that I implemented earlier as I don't have access to client system now.

Thanks,

Sunny

[Former Member]

Sunny,

I think your posting refers to same DB version and fix pack i.e, db2 9.1 fp7.

Your post is for OS: AIX 6.1 TL4

http://scn.sap.com/thread/1782532

Kindly update me if you find any information on this.

Thanks for your quick responses and your replies helped me a lot.

Thanks,

Bharath.

[sunny_pahuja2]

You are referring to one of my old thread. I did not face this problem that time.

Thanks,

Sunny

[Former Member]

Ok thanks..

Thanks,

Bharath.