How can I backup

Look in the command reference for the BACKUP command.
This can also be done from the Control Center. Right click on the database name and pick Backup.

Andy

You backup DB2 data (I assume OS/390) with the COPY command.

The basic format is ==>
COPY TABLESPACE DBNAME.TSNAME

You can also add FULL YES/NO for full and incremential Image copies
and SHRLEVEL CHANGE/REFERENCE for the type of locking SHRLEVEL REFERENCE will allows users to only READ object you are backing up and SHRLEVEL CHANGE will allows users to chage data while backing up, please remember to do a QUIESCE ofter this type of backup to create a point of consistency.

There are other option to create onsite (COPYDDN) and offsite image copy (RECCOVERYDDN), you can use both.

DB2 also allows concurrent image copies but I would stear away from them as it really complicates recover, especially when recovering dropped objects and usingf DSN1COPY.

By the way you can also use the DSN1COPY utility for backing up your data.

> db2 ? backup

-Racha

The Samles I gave a DB2 backup for OS/390 platform.

Hey it is early in the morning here, I am still waking up but what I was trying to say is that the examples I gave are for DB2 OS/390 backups.

I have looked up the Backup command in DB2UDB for Windows NT and here they are:

ONLINE BACKUPS (using Parralelism)

BACKUP DATABASE SAMPLE TABLESPACE USERPACE1 ONLINE TO C:\SQLLIB PARALLELISM 2;

OFFLINE BACKUPS (Using Buffers)

BACKUP DATABASE SAMPLE TABLESPACE USERPACE1 TO C:\SQLLIB WITH 2 BUFFERS;

I hope this helps or lookmore familiar to most people using UDB.