Results 1 to 15 of 15
  1. #1
    Join Date
    Sep 2013
    Posts
    8

    Unanswered: DB2 9.7 Automatic Maintenance - Offline Backup

    Enabled Automatic Maintenance and configured Backup Policy for offline backup. When an offline maintenance window is reached, DB2 engine tries to start offline backup, but fails with error:

    2013-09-13-19.20.00.540695+120 E19757838A766 LEVEL: Severe
    PID : 24183018 TID : 1093 PROC : db2acd 0
    INSTANCE: db2name NODE : 000
    EDUID : 1093 EDUNAME: db2acd 0
    FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1261
    MESSAGE : SQL1035N The database is currently in use.
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1035 sqlerrml: 0
    sqlerrmc:
    sqlerrp : sqlubCon
    sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
    (4) 0x00000000 (5) 0x00000000 (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate: 57019

    2013-09-13-19.20.00.540525+120 E19757398A439 LEVEL: Severe
    PID : 24183018 TID : 1093 PROC : db2acd 0
    INSTANCE: db2name NODE : 000
    EDUID : 1093 EDUNAME: db2acd 0
    FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1261
    DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
    -1035
    DATA #2 : Hexdump, 4 bytes
    0x0000000110529BF8 : FFFF FBF5

    Is Automatic Offline Backup feature supposed to run with any intervention, i.e. deactivating database in advance, or not? If yes, why it doesn't succeed in my case?

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    much easier to create a script and force applications with quiesce command
    schedule this script with crontab or any other at tool
    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
    Sep 2013
    Posts
    8
    Does it mean that offline backup via Automatic Maintenance doesn't work at all/well?

    Any experience with this feature? What are cons/pros of using a script over Automatic Maintenance?

    (The reason why I turned on the folks in this forum is to make Offline Backup via Automatic Maintenance work).

  4. #4
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    This job just tries to take an offline backup.
    It doesn't try to deactivate the db or force all application off. You should do it yourself in advance.
    Regards,
    Mark.

  5. #5
    Join Date
    Sep 2013
    Posts
    11
    if database is in online or archive mode. Is it possible to enable automatic maintenance and take the backup?
    Last edited by zulfiqarali.memon; 09-18-13 at 12:10. Reason: spelling mistake

  6. #6
    Join Date
    Sep 2013
    Posts
    8
    I can see the following in db2diag.log:

    MESSAGE : ADM7506W A request was made to quiesce a database with the following quiesce mode: "QUIESCE DATABASE"

    MESSAGE : ADM7507W Database quiesce request has completed successfully.

    START : DATABASE: NAME : ACTIVATED: NO

    According to this DB2 tries to quiesce database and even deactivate database.

    But then 2 Severe Errors occurs:

    2013-09-13-19.20.39.991980+120 I19762699A444 LEVEL: Severe
    PID : 5832722 TID : 22055 PROC : db2sysc 0
    INSTANCE: db2name NODE : 000 DB : NAME
    APPHDL : 0-48802 APPID: *LOCAL.db2srt.130913172036
    AUTHID : DB2SRT
    EDUID : 22055 EDUNAME: db2agent (SRT) 0
    FUNCTION: DB2 UDB, base sys utilities, sqeApplication::AppStartUsing, probe:140
    RETCODE : ZRC=0xFFFFFBF5=-1035

    2013-09-13-19.20.39.992955+120 E19763144A439 LEVEL: Severe
    PID : 24183018 TID : 1093 PROC : db2acd 0
    INSTANCE: db2name NODE : 000
    EDUID : 1093 EDUNAME: db2acd 0
    FUNCTION: DB2 UDB, database utilities, sqlubConnectDatabase, probe:1261
    DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
    -1035
    DATA #2 : Hexdump, 4 bytes
    0x0000000110529BF8 : FFFF FBF5

    Does anybody knows what does it mean and how to solve it?

  7. #7
    Join Date
    Sep 2013
    Posts
    11
    in which environment you taking backup. o/s, db2 version, circular mode, archive mode. please mention.

  8. #8
    Join Date
    Sep 2013
    Posts
    8
    DB2 for LUW 9.7 FP6 on AIX 6.1 and Archive Mode configured and fully operational.

    I also found the following article:

    IBM Offline database backup failing with SQL1035N : IBM Offline database backup failing with SQL1035N - United States

    If I understand it correctly and if we encounter the same symptoms as IBM describes in the article, it should mean that Automatic Offline Backup (steps DB2 takes to accomplish Offline Backup via Automatic Maintenance) is implemented incorrectly and doesn't work at all.

    Did anybody encounter the same problems?

  9. #9
    Join Date
    Sep 2013
    Posts
    11
    you can use this link. it will help you to understand what you are doing and what you have to do


    Configure automatic maintenance in DB2 for Linux, UNIX, and Windows using IBM Data Studio

  10. #10
    Join Date
    Sep 2013
    Posts
    8
    @zulfiqarali.memon - Thank you for pointing me to the article. I already knew it, in addition it contains only very generic information, it doesn't contain a useful piece of info that could help me in our situation.

  11. #11
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    I'd go for 'good old' cron or ATS. Your way will only work for online backups (what is wrong with that?)
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

  12. #12
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Quote Originally Posted by Kasparek View Post
    If I understand it correctly and if we encounter the same symptoms as IBM describes in the article, it should mean that Automatic Offline Backup (steps DB2 takes to accomplish Offline Backup via Automatic Maintenance) is implemented incorrectly and doesn't work at all.
    No, the key phrase of that note is:
    'When you have users trying to connect in a loop, the timing issue is exposed. If there was no connection attempt, the backup would be successful.'

    Yes, my first note had a mistake: this job doesn't just do a backup attempt but issues a QUIESCE DATABASE command before this.
    But QUIESCE DATABASE doesn't prevent the database manager from the database activation to check if the user trying to connect has DBADM or QUIESCE_CONNECT authorities on this database.

    The only way to prevent these undesirable activations is to QUIESCE INSTANCE with RESTRICT ACCESS MODE.
    But it seems that this Automatic Maintenance job doesn't quiesce the instance, but quiesces only the database.

    See the notes to the RESTRICT ACCESS option of the QUIESCE command.
    Regards,
    Mark.

  13. #13
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by mark.b View Post
    the user trying to connect has DBADM authorities on this database.
    I've seen that once at a client. They 'solved' that by temporarely change the SVCENAME so no remote clients could find the instance anymore...I tend to get goosepickels when I see that kind of constructions.
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

  14. #14
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Quote Originally Posted by dr_te_z View Post
    I've seen that once at a client. They 'solved' that by temporarely change the SVCENAME so no remote clients could find the instance anymore...I tend to get goosepickels when I see that kind of constructions.
    Yes, I've seen the same.
    We have to do such things (alternatively we can use a firewall) since AFAIK there is no ability to prevent let's say remote jobs with SYS* authorities from db activation attempts.
    Regards,
    Mark.

  15. #15
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Yes. It is out answer to the oracle collegues who shout "Cannot you stop the listener" on your database. So we start to sound like Obama: "yes, we can"
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

Posting Permissions

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