Results 1 to 4 of 4

Thread: Backup Up Error

  1. #1
    Join Date
    Mar 2014
    Posts
    2

    Unanswered: Backup Up Error

    Hello everyone,

    I am getting a problem when taking a Online backup in V 9.7 in Linux System.
    When i check the utilities ,the backup is executing until 24% after that it is not working, and it is hanging and it is effecting the performance.
    Some times when i kill the process id of backup, the process is not killing.

    Can i get any suggestions.??


    Thanks & Redards,
    Sankar

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    db2diag.log ?
    list utilities ..
    list applications show detail or sysibmadm view ?
    killing the process : how : db2 force ? or kill
    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
    Mar 2014
    Posts
    2
    2014-03-11-03.03.57.021322+270 E15655E505 LEVEL: Info
    PID : 29067 TID : 140642936153856PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : DB_DB
    APPHDL : 0-63373 APPID: *LOCAL.db2inst1.140316231744
    AUTHID : DB2INST1
    EDUID : 820 EDUNAME: db2agent (DB_DB) 0
    FUNCTION: DB2 UDB, database utilities, sqlubTuneBuffers, probe:871
    DATA #1 : <preformatted>
    Autonomic backup - tuning enabled.
    Using buffer size = 2048, number = 8.

    2014-03-11-03.03.58.962491+270 E16161E452 LEVEL: Info
    PID : 29067 TID : 140642936153856PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : DB_DB
    APPHDL : 0-63373 APPID: *LOCAL.db2inst1.140316231744
    AUTHID : DB2INST1
    EDUID : 820 EDUNAME: db2agent (DB_DB) 0
    FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1533
    MESSAGE : Starting an online db backup.

    2014-03-11-03.13.15.622075+270 E16614E436 LEVEL: Warning
    PID : 29084 TID : 140589900687120PROC : db2acd 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
    MESSAGE : ADM10502W Health indicator "Table Space Operational State"
    ("ts.ts_op_status") is in state "Backup in progress" on "table space"
    "db2inst1.DB_DB .Table_Space_X".

    2014-03-11-03.13.15.624290+270 E17051E441 LEVEL: Warning
    PID : 29084 TID : 140589900687120PROC : db2acd 0
    INSTANCE: db2inst1 NODE : 000
    FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
    MESSAGE : ADM10502W Health indicator "Table Space Operational State"
    ("ts.ts_op_status") is in state "Backup in progress" on "table space"
    "db2inst1.DB_DB .Table_Space_Y".

    ----------------=>After this there is no response regarding the backup in log..

    db2 list utilities

    ID = 619
    Type =
    Database Name = DB_DB
    Partition Number = 0
    Description = online db
    Start Time = 02/14/2014 03:03:57.481596
    State = Executing
    Invocation Type = User
    Throttling:
    Priority = Unthrottled
    Progress Monitoring:
    Estimated Percentage Complete = 21


    =======================
    db2 list applications show detail | grep -i backup

    db2 "FORCE APPLICATION('AGENT_ID')"
    =================
    using the above statements im killing the backup process....

    I have taken backup each tables space individual . Its getting fine.



    Please suggest me how to over come this...

  4. #4
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Quote Originally Posted by Sankar_212192 View Post
    I am getting a problem when taking a Online backup in V 9.7 in Linux System.
    When i check the utilities ,the backup is executing until 24% after that it is not working, and it is hanging and it is effecting the performance.
    Give some precise facts when you ask for help
    what is the fixpack number of the db2-9.7 ?
    Are you backing up to disk?
    Are you backing up to local disk or network disk ?
    What is your exact command-line for the backup?
    If you are backing up to TSM or some 3rd party tool, check the version of the TSM-library and the version/fix level of the vendor library being used...

Posting Permissions

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