How to renaming the Current Active log in DB2 v9?

dineshkannas · New User Joined: 30 Aug 2010 Posts: 5 Location: Mumbai

Hi Friends

I want to rename the current active log VSAM dataset.

Please give the step by step procedure since I am new to DBA.

Thanks in Advance.

Regards
Dinesh Kanna S

GuyC · Posted: Thu Feb 24, 2011 8:07 pm

a simple google : db2 renaming active log dataset

publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc.ugref/db2z_renamedb2activelogdatasets.htm

dineshkannas · New User Joined: 30 Aug 2010 Posts: 5 Location: Mumbai

Thanks for your valuable reply.

I knew this method. Is there any other method to renaming the Current active Log?

enrico-sorichetti · Posted: Fri Feb 25, 2011 12:09 pm

if that method works, any reason to look for something different ?

dineshkannas · New User Joined: 30 Aug 2010 Posts: 5 Location: Mumbai

publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc.ugref/db2z_renamedb2activelogdatasets.htm

this method requires DB2 to be down for two times and force log also.

GuyC · Posted: Fri Feb 25, 2011 5:59 pm

Renaming the active log dataset is not something you have to do every day.
In fact I never had to do that.

dineshkannas · New User Joined: 30 Aug 2010 Posts: 5 Location: Mumbai

We have 150 subsystem in our environment.
so restarting db2 twice will be cumbersome task.

So Let me know some other alternative solution.

dick scherrer · Posted: Sun Feb 27, 2011 1:09 am

Hello,

Why does someone believe this is even necessary. . .

Many (most?) places do not do this regularly if at all.

Why does your system need this 150 places. . .

If this is actually to be done, suggest you follow the already documented/accepted method and not implement something else.