Hi, i am new in DB2,i want to know how to take backups of the database.
i have made a demo database on my machine and i am accessing that database from control center.
i want to know how to take backup of that database and how to recover the backup to database if something goes wrong.

and the procedure of taking backup is same for local and remote database???

You can right click on the database name from Control Center to do backup and restore. The actual commands are documented in the Command Reference manual.

SQL2071N An error occurred while accessing the shared library
"C:\SANCHIT_BACKUP". Reason code: "1".

Explanation:

An unexpected error occurred while accessing a vendor shared library
during the processing of a database utility. The following is a list of
reason codes:

1 An invalid shared library path was encountered.

2 The library could not be loaded because it (or a library
required by it) does not exist or does not have a valid format.
This sometimes means that a 32-bit library is being loaded in a
64-bit instance, or vice-versa.

3 An error was encountered while unloading the shared library.

The utility stops processing.

User response:

Responses by reason code:

1 Specify a correct path in the restore or backup command. Make
sure the path is valid and contains the correct shared library.
For more information on the backup and restore commands, search
the DB2 Information Center
(http://publib.boulder.ibm.com/infocenter/db2luw/v9) using
terms such as "restore database command" or "backup database
command".

2 Ensure that you are specifying the correct library. If your
system can run 32-bit and 64-bit binaries, ensure that you are
instructing DB2 to load a library of the right format.

If the failure occurs while using TSM, verify that the TSM API
Client is properly installed.



See the DB2 Diagnostics Log (db2diag.log) for more information.


3 Ensure that version of TSM client being used is compatible with
your DB2 instance. For more information, search the DB2
Information Center
(http://publib.boulder.ibm.com/infocenter/db2luw/v9) using
terms such as "TSM clients".



BUT THE BACK IS WORKING FINE IF I TRY FROM COMMAND PROMPT USING

db2 backup database dbname

gotcha...

Backing up
db2 backup database dbname to c:\

Restoring
db2 restore database dbname from c:\ taken at 20090505145915

20090505145915--> is the timestamp given to you while backing up the database..


but this is only for local databases...