Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2012
    Posts
    177

    Unanswered: Need Help for online partioning database backup

    Hi all,

    In our setup db2 V9.7 with fixpack 4

    Facing issues with taking the online backup for partitioning database:

    [db2inst1@prddw1 ~]$ db2 backup db XXX ON ALL DBPARTITIONNUMS ONLINE to /db2prod/temp
    Part Result
    ---- ------------------------------------------------------------------------
    0000 SQL2001N The utility was interrupted. The output data may be incomplete.
    0001 SQL2001N The utility was interrupted. The output data may be incomplete.
    0002 SQL0276N Connection to database "XXX" cannot be made because it is in
    the restore pending state.

    SQL2429N The database backup failed. The following database partitions
    returned errors: "2".



    I searched in db forums i got the information like need to increase the MAXFILOP :

    I checked the file-max in /etc/sysctl.conf. And I was also issuing cat /proc/sys/fs/file-nr to determine the usage. At the same time I also monitored lsof | wc -l and found that it was crossing the threshold (from db forums)

    Max DB files open per application (MAXFILOP) = 61440

    [root@prddw3 ~]# cat /proc/sys/fs/file-nr
    3570 0 4773179

    [root@prddw3 ~]# lsof | wc -l
    4295


    As I am new for this, i am trying the same to resolve this error..

    could you please give me the suggestion how to resolve this issue

    Thanks,
    laxman..

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    SQL0276N : this should be corrected first
    have a look at diaglog for details
    If I were new to DB2 the first thing I would look at : messages and codes : to understand what is going on..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jan 2013
    Posts
    15
    The issue as to why the backup fails is seen in the backup command output:

    [db2inst1@prddw1 ~]$ db2 backup db XXX ON ALL DBPARTITIONNUMS ONLINE to /db2prod/temp
    Part Result
    ---- ------------------------------------------------------------------------
    0000 SQL2001N The utility was interrupted. The output data may be incomplete.
    0001 SQL2001N The utility was interrupted. The output data may be incomplete.
    0002 SQL0276N Connection to database "XXX" cannot be made because it is in
    the restore pending state.

    While connecting to node 2 for the backup, the connection fails as the database on node 2 is in a restore pending state. You need to fix this before being able to take the backup.

    To test the connection state:

    db2_all "<<+2<db2 connect to <dbname>"

    Cheers,
    Hans

Posting Permissions

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