Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    70

    Unanswered: SNAP backup got failed

    Hi,

    Our SNAP backup got failed

    FUNCTION: DB2 UDB, buffer pool services, sqlbGetPreventSuspendLatchExclusive, probe:10
    MESSAGE : ZRC=0x80020154=-2147353423=SQLB_NOT_ALLOWED_BACKUP_IN_PRGRS
    "Access not allowed. Backup in progress."
    DATA #1 : String, 59 bytes
    Error: could not get preventSuspend latch in EXCLUSIVE mode

    Informational tokens are "DB2 v9.5.0.5", "and
    Fix Pack "5".



    Please help us to reslove this issue.

    Regards,
    Raj

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    What a coincidence! Was testing this scenario less than an hour ago.

    If you issue a SET WRITE SUSPEND command when an online backup is in progess, SQL1550N is returned (rc=2) and the above message is recorded in the diagnostic log.

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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