Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    2

    Unanswered:

    We are trying to access a cobol stored procedure on zOS using
    DB2 Connect V8.1 fp7b RTC via an AIX server, we are able
    to connect to the database on zOS, however when try to access
    the stored procedure we get the following error:

    IBM][CLI Driver] SQL0998N. Error occurred during transaction or
    heuristic processing. Reason code = ?16?. Subcode = ?2-80004005?.
    SQLstate = 58005

    Any ideas?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Look out for more information in Stored Proc Address space, Distributed address space and master address space on zoS . Also check the client's db2diag.log file ..

    If these do not help, try a db2 cli trace also ..

    Even before that, are you able to successfully call the procedure on zOS itself ?

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

  3. #3
    Join Date
    Feb 2006
    Posts
    2
    Nothing showed up in Stored Proc Address space, Distributed address space and master address space on zoS. Also nothing showed up in the db2diag.log.

    I will try a DB2 CLI trace.

    Yes this is a production Stored procedure that has been working fine and
    can be called from z/OS.

    Thanks
    Chuck

Posting Permissions

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