DB2 7.1 backup question

[Mag0007]

Hello:

I just aquired a Db2 7.1 server, and I am very new at this. Its running AIX. There is one instance running on the server. How can I check if the database backup has ran? and it completed in a good state?

TIA!

 

[rbod]

If the backup did not run properly it will complain immediately.

To list all the backups already taken:
list history backup all for db <db_name>

To list backups since a particular period of time:
list history backup since <time_stamp> for db <db_name>
ex:db2 list history since 20051001 for db sample

 

[Mag0007]

do I type this in on the UNIX shell?

or somewhere else?

 

[rbod]

yes.
$db2 list history since 20051001 for db sample

You can also do it from db2 interactive mode.
At the prompt type db2 [and hit enter]
$db2
this will take you into interactive mode :
db2=>
now you can just type in the command, without "db2" prefix.
db2=>list history since 20051001 for db sample
db2=>quit

 

[Mag0007]

Thanks..

I am not really sure what the database name is either...

Would the database name be the instance name?

 

[Mag0007]

seems the instance name works....

 

[Mag0007]

Ha..okay..thanks it works, but how should I know if it was success or failure?

 

[rbod]

to see all the instances
$db2ilist
to see a list of the databases:
$db2 list db directory

When the backup command was issued, if there was a problem, it will complain or throw an error at that time itself. If there was a problem, then backup is not completed and it does not show up in the list history results.
Whatever you see in the list history results, are successful backups.

 

[Mag0007]

Thanks!

How can I check the size of the database? Not rows or columns, but in megabytes? I am not too sure if we are getting full backups....

 

[Mag0007]

Guys:

I do have something like this:
Comment: DB2 BACKUP ARCHIVE OFFLINE
Start Time:
End Time:
------------------------------------
Location:/db2backup

How can I check if that instance was a success?

BTW, I have 1680 tablespaces, Type =F, Dev=D

Can someone please explain to me what this means? I just want to make sure my DB is being backed up (again).


TIA!