Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2012
    Posts
    1

    Unanswered: Creating SQL stored procedure

    I'm running a deploy on IBM Data Studio v3.1 (running in Windows) to create a stored procedure to a DB2 running in mainframe MVS and getting an abend 913. How can I figure out what is causing the precompile to fail?


    PRECOMPILE SQLTERM 1 SOURCE STATISTICS
    PRECOMPILE SQLTERM 2 SOURCE LINES READ: 49
    PRECOMPILE SQLTERM 3 NUMBER OF SYMBOLS: 22
    PRECOMPILE SQLTERM 4 SYMBOL TABLE BYTES EXCLUDING ATTRIBUTES: 3960
    PRECOMPILE SQLTERM 5 THERE WERE 0 MESSAGES FOR THIS PROGRAM.
    PRECOMPILE SQLTERM 6 THERE WERE 0 MESSAGES SUPPRESSED BY THE FLAG OPTION.
    PRECOMPILE SQLTERM 7 297056 BYTES OF STORAGE WERE USED BY THE PRECOMPILER.
    PRECOMPILE SQLTERM 8 RETURN CODE IS 0
    DSNTPSMP CONSOLE 1 *** DB2 V10R1 SQL Procedure Processor DSNTPSMP 1.21 (DB2V10R1 2010-03-19)
    DSNTPSMP CONSOLE 2 Precompile warnings and/or errors, rc=-2323
    DSNTPSMP CONSOLE 3 Abend 913 occurred while running Precompile program DSNHPC
    DSNTPSMP CONSOLE 4 Precompile of C source is not successful, cannot continue

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    IIRC the 913 is a timeout/deadlock issue.

    This sometimes happens when something else is running using the resource.

  3. #3
    Join Date
    Apr 2008
    Posts
    39
    see what other application / jobs are running while you are doing the deployment. Might be possible your deployment is using resources which are
    already being used by other job or application. So better to clear all locks
    before doing the deployment ( Just a guess).

    thanks
    Naval k

  4. #4
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Ahh - probably not a good idea to just blindly clear all locks - unless the system is taken out of service for this process.

    Possibly i misunderstand.

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
  •