2 Questions in rollforward operation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

arunrocks@gmail.com - 26 Apr 2007 16:49 GMT

Plz help.
1. how can we give tsm as overflowlogpath in rollforward command, if
it is not being used as logarchmeth1 (db2 searches this dir)
2. how can we change the load copy file's directory, since I dont have
the drive letter that I used in original db in this copy server?? I
can map it to the same letter, but it is taken by other operations
already..

Reply to this Message

Keith - 27 Apr 2007 20:31 GMT

On Apr 26, 11:49 am, arunro...@gmail.com wrote:

> Plz help.
> 1. how can we give tsm as overflowlogpath in rollforward command, if
[quoted text clipped - 3 lines]
> can map it to the same letter, but it is taken by other operations
> already..

1. Use db2adutl to extract logs from tsm to a local directory. Then
use this directory for overflowlogpath in RF.
2. Check out DB2LOADREC registry variable.

Keith Ponnapalli
IBM Certified Advanced Database Administrator - DB2 UDB V8.1 LUW
IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration
INFORMIX Certified Database Administrator

Reply to this Message

arunrocks@gmail.com - 27 Apr 2007 21:19 GMT

> On Apr 26, 11:49 am, arunro...@gmail.com wrote:
>
[quoted text clipped - 14 lines]
> IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration
> INFORMIX Certified Database Administrator

Thanks Keith. It was great to know about the registery variable.. But
it is not set in my machine and as I read about this, I think we set
this to change
the location of load copy files during restore and follow the
structure as given.
But if not set, are there any files in the db2 directory that we can
look into adn
see where the load copy files are (just to find them??)
Thanks a lot for that one..

Reply to this Message

Keith - 28 Apr 2007 12:48 GMT

On Apr 27, 4:19 pm, arunro...@gmail.com wrote:

> > On Apr 26, 11:49 am, arunro...@gmail.com wrote:
>
[quoted text clipped - 26 lines]
>
> - Show quoted text -

The files should be in : <database directory>/NODE????/SQL????/load/
-- depending on # of partitions.

Keith Ponnapalli
IBM Certified Advanced Database Administrator - DB2 UDB V8.1 LUW
IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration
INFORMIX Certified Database Administrator

Reply to this Message