Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2009
    Posts
    14

    Unanswered: How to take backups in DB2

    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???
    Please don't spam!

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Feb 2009
    Posts
    14

    error while taking backup from control centre

    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
    Please don't spam!

  4. #4
    Join Date
    Feb 2009
    Posts
    14
    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...
    Please don't spam!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •