DB2 - L

  • 1.  ADMIN_INFO_SYSPARM getting -482

    Posted Sep 24, 2021 09:52 PM
    trying to run ADMIN_INFO_SYSPARM and getting -482.
    it states the procedure returned no locators?
    please advise
    thanks
    Bill

    ------------------------------
    williamgiannelliMe
    ------------------------------


  • 2.  RE: ADMIN_INFO_SYSPARM getting -482

    Posted Sep 26, 2021 02:00 AM
    Edited by Jørn Thyssen Sep 26, 2021 02:00 AM
    What is tool are you using to call the SP? 

    My preferred tools for ad-hoc testing of SPs are IBM Db2 Admin Tool or Data Studio.

    ------------------------------
    Jørn Thyssen
    Rocket Software
    2021 IBM Champion
    ------------------------------



  • 3.  RE: ADMIN_INFO_SYSPARM getting -482

    Posted Sep 26, 2021 07:02 PM
    What was the SQLCODE from the the actual call to ADMIN_INFO_SYSPARM?

    As far as I can gather, a successful call to ADMIN_INFO_SYSPARM should return:
    - SQLCODE = 466 (i.e. result sets returned)
    - rc (the second parameter) = 0
    - second message token (in SQLERRMC) = "1" (i.e. one result set)

    If:
    - SQLCODE = 0
    - rc > 0 (i.e. an error occurred)
    then the message (the third parameter) contains a message indicating what the error was.

    I don't know if other non-negative SQLCODEs with rc=0 are possible or what they would
    mean.

    James Campbell

    On 25 Sep 2021 at 1:51, william giannelli via Interna wrote:

    > trying to run ADMIN_INFO_SYSPARM and getting -482.
    > it states the procedure returned no locators?
    > please advise
    > thanks
    > Bill
    >
    > ------------------------------
    > williamgiannelliMe
    > ------------------------------
    >
    >

    --
    This email has been checked for viruses by AVG.
    https://www.avg.com




  • 4.  RE: ADMIN_INFO_SYSPARM getting -482

    Posted Sep 26, 2021 07:19 PM
    Hello William,

    I have uploaded a working rexx program into the Library area of Db2-L that calls ADMIN_INFO_SYSPARM. Lets see if that helps you.

    Regards, Peter Schwarcz


    ------------------------------
    PeterSchwarczSchwarcz Computer Services
    ------------------------------