db2 get snapshot for tablespaces on <SID>

manikandank_1984 · #1 (**permalink**) 03-26-09, 01:18

Hi,

I have executed this command.We have totally 37 tablespaces in DB2.After executed this command i able to see last part only in screen i.e 37th tablespace details only.I want to see the all the tablespace datails in single screen.Can you tell me how to see.

Regards,
Maj

nick.ncs · #2 (**permalink**) 03-26-09, 01:44

that issue is OS related and not db2..

Redirect output to a text file or scroll upwards to see other details

manikandank_1984 · #3 (**permalink**) 03-26-09, 01:55

Hi,

Thanks for your reply.

What is the command to redirect to text file.

Regards,
Maj.

nick.ncs · #4 (**permalink**) 03-26-09, 10:42

Read the db2 manual for GET SNAPSHOT command it has been well documented... or else pay me your salary and i'll help you 24x7

db2dummy1 · #5 (**permalink**) 03-26-09, 21:32

from the sound of it, he just may take you up on the offer

... sorry, could not resist

Satyenderm · #6 (**permalink**) 04-08-10, 01:16

Quote:

Originally Posted by manikandank_1984

Hi,

Thanks for your reply.

What is the command to redirect to text file.

Regards,
Maj.

Hi all,

I know that I am replying to this old thread.
I think this would help the people who would search for the particular topic in the future.

Herein is the answer:

db2> DB2 GET SNAPSHOT FOR DATABASE ON SAMPLE > C:\SNAP.TXT