db2adutl query full

[forbidth]

when i use command "db2adutl query full" with user root
i can see more file but i use "db2adutl query full" with user db2
cannot see backup file

why ?

 

[ChrisRees]

Hi

do you get any errors at all when you use the db2 user? or is it just it finds no backup images?

Cheers

 

[forbidth]

yes just only no backup file, not error
but now i use command
"db2adutl query db (database) nodename (node) password (password&gt)
in this case, can i restore whit command "db2 restore" ?

 

[ChrisRees]

You can try a restore, obviously you'll use the timestamp that you can see from the "db2adtul query db" command. It might not work though as you cannot specify <nodename> and <password> with db2 restore.

can you post your dsm.sys file and also your entries as follows from db2 get db cfg for <database>

TSM management class (TSM_MGMTCLASS)
TSM node name (TSM_NODENAME)
TSM owner (TSM_OWNER)
TSM password (TSM_PASSWORD)

Cheers

 

[forbidth]

i just use

"db2 update db cfg" for update TSM node name and TSM password but can not restore error is

SQL2542N No match for a database image file was found based on the source
database alias "EDWP" and timestamp "20111101004248" provided