2 Questions in rollforward operation

[arunrocks]

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..

[Keith]

On Apr 26, 11:49 am, [e-mail] wrote:

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..

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

[arunrocks]

On Apr 27, 2:31 pm, Keith <[e-mail]:

On Apr 26, 11:49 am, [e-mail] wrote:

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..

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

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..

[Keith]

On Apr 27, 4:19 pm, [e-mail] wrote:

On Apr 27, 2:31 pm, Keith <[e-mail]:

On Apr 26, 11:49 am, [e-mail] wrote:

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..

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

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..- Hide quoted text -

- 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