Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2015
    Posts
    5

    Unanswered: Sqlcode -911 in Data Replication via Dpropr

    Hello , I am getting sqlcode -911 in replicating data from source system via Dpropr. Following is the job log

    ASN1001E APPLY "APPIWCUS" : "WorkerThread". The Apply program 179
    encountered an SQL error. The ERRCODE is "3F0102". The SQLSTATE
    is "40001". The SQLCODE is "-911". The SQLERRM is
    "00C900BA.00002002.DPROPR .ROWTS". The SQLERRP is "DSNXRUP2".
    The server name is "EUBADB2A ". The table name is
    "ASN.IBMSNAP_SUBS_SET".

    Can any one help ?

    Thanks in advance
    Paresh

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if you would have specified some details about db2level/platform/source/target we would not have to guess what is going on
    error on source/target/control db ?
    sqlcode is deadlock or lock timeout
    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
    Jun 2015
    Posts
    5

    Re : Sqlcode -911 in Data Replication via Dpropr

    Quote Originally Posted by przytula_guy View Post
    if you would have specified some details about db2level/platform/source/target we would not have to guess what is going on
    error on source/target/control db ?
    sqlcode is deadlock or lock timeout
    Hi,
    Following is the source and target DB2 version details
    Source DB2 - DB2/AIX64 Version 10.1.3
    Target DB2 - DB2 z/OS 10.1.5
    Earlier it was working fine. I dont know why suddenly we started getting this error as no changes were made. Sometimes, it runs fine sometimes it throws error.

    Thanks

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    deadlock
    where are control tables located ?
    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

  5. #5
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hello Paresh,

    00C900BA is a drain lock for the tablespace DPROPR.ROWTS (resource type 2002).
    Probably some application doesn't allow dprop to lock the tablespace in the mode specified.
    Ask your db admin to look at the applications locking this tablespace.
    Regards,
    Mark.

  6. #6
    Join Date
    Jun 2015
    Posts
    5

    Re : Sqlcode -911 in Data Replication via Dpropr

    Quote Originally Posted by przytula_guy View Post
    deadlock
    where are control tables located ?
    Hi ,
    Prune tables, Register tables are present at source server and Subscriptions tables are present at target server.

    Thanks

  7. #7
    Join Date
    May 2012
    Location
    Canberra, Australia
    Posts
    176
    Provided Answers: 6
    As Mark suggested, what was the response from the m/f DBA?
    Andy

    "All parts should go together without forcing. You must remember that the parts you are reassembling were disassembled by you. Therefore, if you can’t get them together again, there must be a reason. By all means, do not use hammer.” — IBM maintenance manual, 1975 "

Tags for this Thread

Posting Permissions

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