IBM i Global

 View Only
Expand all | Collapse all

acs upgrade 1.1.9.0

  • 1.  acs upgrade 1.1.9.0

    Posted Tue May 24, 2022 10:06 AM
    One of the things i like about this upgrade is the tabs on Run SQL Scripts
    but i have noticed that my 5250 sessions all still say 1.1.8.4 and as a result the Run Sql Scripts when opened from the 5250 session are also 1.1.84 and don't have the tab function available. 
    I've tried recreating my .hod files but this still just creates 1.1.84 5250 sessions. 
    Even opening 5250 from the main ACS panel creates 1.1.84  5250 sessions. 

    Is this just a piece that did not get updated, or is there something else i need to to do get the 5250 sessions at 1.1.9

    Not a huge deal, but it would be nice to lauch the new run sql scripts from my 5250 session.

    Thanks
    mike

    ------------------------------
    Michael Smith
    ------------------------------


  • 2.  RE: acs upgrade 1.1.9.0

    IBM Champion
    Posted Wed May 25, 2022 04:06 AM

    Hi Michael.

    If you have different version number in Run SQL Script and 5250 session, then you are running two instances and two different versions of ACS.
    You can have as many ACS installed as you like - it's just a JAR file on your workstation (or network drive). If you want to know the version and location of the ACS JAR file, open Help -> About... it is shown just below the build date:


    If you open your 5250 sessions by clicking (shortcuts to) the .hod files, then ACS is registered in Windows as the application to run .hod files and it is this one instance of ACS, that you should upgrade to 1.1.9.0.

    It is nice to be able to have multiple ACS installed, e.g. for testing new versions of ACS before upgrading - but it can also be confusing, if you don't clean up afterwards. Been there, done that! ;-)

    Best regards,
    Christian



    ------------------------------
    Christian Jorgensen
    IT System Administrator
    Network of Music Partners A/S
    ------------------------------



  • 3.  RE: acs upgrade 1.1.9.0

    Posted Wed November 02, 2022 09:03 AM

    Hello Christian,

    I've encountered an issue while using IBM ACS 1.1.8.8, I could successfully run CL commands from "Run SQL Scripts" window, but I'm unable to get/read the results. The CL command I'm using is "CL: DSPOBJ QSYS *LIB;" 

    Is there any temporary table, or cache or any env variable storing this result?? or it simply should not accept such commands?

    Please let me know your opinion on this.

    Thanks
    -
    Ojsv



    ------------------------------
    Ojasva Bhardwaj
    ------------------------------



  • 4.  RE: acs upgrade 1.1.9.0

    IBM Champion
    Posted Wed November 02, 2022 09:14 AM
    Hi Ojsv

    I hope you run the DSPOBJD command - there is no command called DSPOBJ (without a 'D')...! ;-)

    The DSPOBJD returns output as *PRINT when run in a non-interactive job, so you need to find the spoolfile generated by your command. The easy way from Run SQL Script is to go into the Tools menu and select "Printer Output".

    In the Printer Output view you can filter the spoolfiles by user (*CURRENT) and date (and more). By setting the filter correct, you will get a list containing your newly created spoolfile.

    Hope this helps!

    Best regards,
    Christian

    ------------------------------
    Christian Jorgensen
    IT System Administrator
    Network of Music Partners A/S
    ------------------------------



  • 5.  RE: acs upgrade 1.1.9.0

    Posted Thu November 03, 2022 01:42 AM
    Hello Christian,

    Thank you for your quick response

    That's correct about the DSPOBJ command, but I wonder why it ran successfully on my machine and looks like it's actually a command by TAATOOL. :p

    I found the report at "Printer Output". Thank you for directing me to there :) 

    -
    Best,
    Ojsv

    ------------------------------
    Ojasva Bhardwaj
    ------------------------------



  • 6.  RE: acs upgrade 1.1.9.0

    Posted Wed November 02, 2022 09:14 AM
    Hi,

    you can use the SPOOLED_FILE_DATA service in SYSTOOLS or the READSPLF table function from Bob Cozzis SQLTOOLS (if you have these). 

    Just make sure, to always read the spoils from the right job (*). 

    HTH
    Daniel





  • 7.  RE: acs upgrade 1.1.9.0

    Posted Thu November 03, 2022 01:46 AM
    Hi Daniel,

    This is new for me but I think something went wrong while trying. Here are the steps I took and the error I received.

    Right after running the DSPOBJD CL command, I tried running following SQL query using the job for 'RUN SQL Scripts'

    SELECT * FROM
    TABLE (SYSTOOLS.SPOOLED_FILE_DATA (JOB_NAME =>'987658/QUSER/QZDASOINIT', SPOOLED_FILE_NAME =>'QPRTOBJD'))
    ORDER BY ORDINAL_POSITION

    --QPRTOBJD - Output spool for DSPOBJD

    Error:  
    SQL State: 42704 Vendor Code: -438 Message: [SQL0438] FAILURE ON CPYSPLF Cause . . . . . :   An application has executed a SIGNAL or RESIGNAL statement, the RAISE_ERROR function has been invoked, or an error was signalled within a MERGE statement. If the application is an SQL procedure, function, trigger, or a compound (dynamic) statement, the SQLSTATE was not handled in the SQL routine.  The message returned is FAILURE ON CPYSPLF. Recovery  . . . :   See the documentation for the application that issued the SIGNAL or RESIGNAL statement or invoked the RAISE_ERROR function.

    Any clue how this could work?
    -
    Best,
    Ojsv

    ------------------------------
    Ojasva Bhardwaj
    ------------------------------



  • 8.  RE: acs upgrade 1.1.9.0

    Posted Thu November 03, 2022 02:01 AM
    Hi Ojasva,

    the first question is, which information about an object do you need? Because most object info is available via system services like OBJECT_STATISTICS(...) or simply SYSTABLES. 

    And I found, that when you play around with CL commands and retrieving their outputs, it's easier to try that on the green screen - run the command and then STRSQL and try to retrieve the output from JOB_NAME=>'*' - if this works - it should work the same way in iACS. 

    But if it doesn't work, ist far easier to look into the joblog for additional info. 

    I think, that the SPOOLED_FILE_DATA(...) table function just doesn't find the right spool file - or there is some sort of permission problem. 

    HTH
    Daniel





  • 9.  RE: acs upgrade 1.1.9.0

    Posted Thu November 03, 2022 08:33 AM
    I agree with Daniel that OBJECT_STATISTICS is the way to go.
    to read the last spooled file from your ODBC job takes a bit more to find it.

    There exists a pre-built example from IBM, that i just tried and it "found" the output from TAATOOL/DSPOBJD

    -- category: IBM i Services
    -- description: Spool - Consume my most recent spooled file
    --
    -- Query my most recent spooled file
    --
    WITH my_spooled_files (
    job,
    FILE,
    file_number,
    user_data,
    create_timestamp
    )
    AS (SELECT job_name,
    spooled_file_name,
    file_number,
    user_data,
    create_timestamp
    FROM qsys2.output_queue_entries_basic
    WHERE user_name = USER
    ORDER BY create_timestamp DESC
    LIMIT 1)
    SELECT job,
    FILE,
    file_number,
    spooled_data
    FROM my_spooled_files,
    TABLE (
    systools.spooled_file_data(
    job_name => job, spooled_file_name => FILE,
    spooled_file_number => file_number)
    );

    ------------------------------
    Bryan Dietz
    ------------------------------



  • 10.  RE: acs upgrade 1.1.9.0

    Posted Wed May 25, 2022 07:34 AM
    I don't start from a .hod icon.  I start ACS up (looking at the about it shows 1.1.9.0) and then start a 5250 emulator (again, the about shows 1.1.9.0).  So my first guess, would be to look that my .hod link properties and make sure it is pointing to the 1.1.9.0 install that you just did.  

    If it does, please let us know and I will have to think some more.

    ------------------------------
    Mark Soulje
    ------------------------------



  • 11.  RE: acs upgrade 1.1.9.0

    Posted Wed May 25, 2022 08:06 AM
    If the <help><about> shows 1.1.8.4 then i think you may have an older version of the "acsbundle.jar" somewhere on the PC.
    on 1.1.9.0 i see the path to the jar file

    Emulator
    acshod-B20220412_140118
    (64-bit)
    11.0.8-B20130530
    Version: 1.1.9.0
    Build id: 2151
    2022-04-06 15:18:47
    C:\IBM\ACS\acsbundle.jar
    ---
    Run SQL Scripts
    (64-bit)
    Version: 1.1.9.0
    Build id: 2151
    2022-04-06 15:19:51
    C:\IBM\ACS\acsbundle.jar

    ------------------------------
    Bryan Dietz
    ------------------------------



  • 12.  RE: acs upgrade 1.1.9.0

    Posted Wed May 25, 2022 10:22 AM
    I did find another copy and have gotten rid of it. 
    I now see 1.1.9 on my 5250 session.   
    Thanks for the help

    ------------------------------
    Michael Smith
    ------------------------------