Cobol call to SYSPROC.ADMIN_INFO_SYSPARM failiing DB2 Z/Os V11

Stephen Cox

Cobol call to SYSPROC.ADMIN_INFO_SYSPARM failiing DB2 Z/Os V11

I have a cobol program calling SYSPROC.ADMIN_INFO_SYSPARM in DB2 Z/Os V10 which works OK at one site, but trying it at another site using DB2 V11 it fails on the ASSOCIATE LOCATORS:

DSNT408I SQLCODE = -482, ERROR:  THE PROCEDURE ADMIN_INFO_SYSPARM RETURNED NO LOCATORS

I have searched high and low, tried many things compared configuration, authorizations and options, but no solution yet! Any Ideas!

Code Snippet:

 EXEC SQL                                          
     CALL SYSPROC.ADMIN_INFO_SYSPARM               
      (:WS-CALL-DB2-MEMBER :WS-CALL-IND-DB2-MEMBER 
      ,:WS-CALL-RETCD :WS-CALL-IND-RETCD           
      ,:WS-CALL-ERRMSG :WS-CALL-IND-ERRMSG)        
 END-EXEC.   

------------------------------------

EXEC SQL                                         
    ASSOCIATE LOCATORS (:WS-LOCVAR)              
        WITH PROCEDURE SYSPROC.ADMIN_INFO_SYSPARM
END-EXEC.                                                                              

Stan Goodwin

Cobol call to SYSPROC.ADMIN_INFO_SYSPARM failiing DB2 Z/Os V11
(in response to Stephen Cox)
Steven, if you have not gotten the answer, get with db2 sysprog and check syslog for any other errors that maybe occurring prior to this one, also make sure you have authority to execute the package DSNADMIZ

Sent from my iPad

> On Jul 28, 2015, at 01:52, Stephen Cox <[login to unmask email]> wrote:
>
> I have a cobol program calling SYSPROC.ADMIN_INFO_SYSPARM in DB2 Z/Os V10 which works OK at one site, but trying it at another site using DB2 V11 it fails on the ASSOCIATE LOCATORS:
>
> DSNT408I SQLCODE = -482, ERROR: THE PROCEDURE ADMIN_INFO_SYSPARM RETURNED NO LOCATORS
>
> I have searched high and low, tried many things compared configuration, authorizations and options, but no solution yet! Any Ideas!
>
> Code Snippet:
>
> EXEC SQL
> CALL SYSPROC.ADMIN_INFO_SYSPARM
> (:WS-CALL-DB2-MEMBER :WS-CALL-IND- DB2-MEMBER
> ,:WS-CALL-RETCD :WS-CALL-IND-RETCD
> ,:WS-CALL-ERRMSG :WS-CALL-IND-ERRMSG)
> END-EXEC.
>
> ------------------------------------
>
> EXEC SQL
> ASSOCIATE LOCATORS (:WS-LOCVAR)
> WITH PROCEDURE SYSPROC.ADMIN_INFO_SYSPARM
> END-EXEC.
>
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
> ** ** ** Attend the 2015 IDUG EMEA DB2 Tech Conference ** ** **
> ---> Dublin, Ireland 15-20 November, 2015 <---
> http://www.idug.org/p/cm/ld/fid=639
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2

Stephen Cox

Cobol call to SYSPROC.ADMIN_INFO_SYSPARM failiing DB2 Z/Os V11
(in response to Stan Goodwin)
Thanks Stan, Appreciated, I have checked all that previously, still digging! ☺

From: Stanley Goodwin [mailto:[login to unmask email]
Sent: 28 July 2015 07:41 PM
To: [login to unmask email]
Subject: [DB2UGCENPA] - RE: Cobol call to SYSPROC.ADMIN_INFO_SYSPARM failiing DB2 Z/Os V11

Steven, if you have not gotten the answer, get with db2 sysprog and check syslog for any other errors that maybe occurring prior to this one, also make sure you have authority to execute the package DSNADMIZ

Sent from my iPad

On Jul 28, 2015, at 01:52, Stephen Cox <[login to unmask email]<mailto:[login to unmask email]>> wrote:

I have a cobol program calling SYSPROC.ADMIN_INFO_SYSPARM in DB2 Z/Os V10 which works OK at one site, but trying it at another site using DB2 V11 it fails on the ASSOCIATE LOCATORS:

DSNT408I SQLCODE = -482, ERROR: THE PROCEDURE ADMIN_INFO_SYSPARM RETURNED NO LOCATORS

I have searched high and low, tried many things compared configuration, authorizations and options, but no solution yet! Any Ideas!

Code Snippet:

EXEC SQL
CALL SYSPROC.ADMIN_INFO_SYSPARM
(:WS-CALL-DB2-MEMBER :WS-CALL-IND- DB2-MEMBER
,:WS-CALL-RETCD :WS-CALL-IND-RETCD
,:WS-CALL-ERRMSG :WS-CALL-IND-ERRMSG)
END-EXEC.

------------------------------------

EXEC SQL
ASSOCIATE LOCATORS (:WS-LOCVAR)
WITH PROCEDURE SYSPROC.ADMIN_INFO_SYSPARM
END-EXEC.

-----End Original Message-----

-----End Original Message-----

Disclaimer: This message and/or attachment(s) may contain privileged, confidential and/or personal information. If you are not the intended recipient you may not disclose or distribute any of the information contained within this message. In such case you must destroy this message and inform the sender of the error. T-Systems does not accept liability for any errors, omissions, information and viruses contained in the transmission of this message. Any opinions, conclusions and other information contained within this message not related to T-Systems' official business is deemed to be that of the individual only and is not endorsed by T-Systems.

This message and/or attachment(s) may contain privileged or confidential
information. If you are not the intended recipient you may not disclose or
distribute any of the information contained within this message. In such
case you must destroy this message and inform the sender of the error.
T-Systems does not accept liability for any errors, omissions, information
and viruses contained in the transmission of this message. Any opinions,
conclusions and other information contained within this message not related
to T-Systems' official business is deemed to be that of the individual only
and is not endorsed by T-Systems.

T-Systems - Business Flexibility

Stan Goodwin

Cobol call to SYSPROC.ADMIN_INFO_SYSPARM failiing DB2 Z/Os V11
(in response to Stephen Cox)
Steven, Have you got this resolved. If not please email me directly
[login to unmask email]
Sent from my iPad

On Jul 28, 2015, at 01:52, Stephen Cox <[login to unmask email]> wrote:

I have a cobol program calling SYSPROC.ADMIN_INFO_SYSPARM in DB2 Z/Os V10
which works OK at one site, but trying it at another site using DB2 V11 it
fails on the ASSOCIATE LOCATORS:
DSNT408I SQLCODE = -482, ERROR: THE PROCEDURE ADMIN_INFO_SYSPARM RETURNED
NO LOCATORS
I have searched high and low, tried many things compared configuration,
authorizations and options, but no solution yet! Any Ideas!
Code Snippet:
EXEC SQL
CALL SYSPROC.ADMIN_INFO_SYSPARM
(:WS-CALL-DB2-MEMBER :WS-CALL-IND- DB2-MEMBER
,:WS-CALL-RETCD :WS-CALL-IND-RETCD
,:WS-CALL-ERRMSG :WS-CALL-IND-ERRMSG)
END-EXEC.
------------------------------------
EXEC SQL
ASSOCIATE LOCATORS (:WS-LOCVAR)
WITH PROCEDURE SYSPROC.ADMIN_INFO_SYSPARM
END-EXEC.


Site Links: View post online View mailing list online Start new thread
via email Unsubscribe from this mailing list Manage your subscription
** ** ** Attend the 2015 IDUG EMEA DB2 Tech Conference ** ** **
---> Dublin, Ireland 15-20 November, 2015 <---
http://www.idug.org/p/cm/ld/fid=639

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2