Toolkit errors after update

[timo_karvinen]

I can honestly assure you that anything said in this thread has absolutely nothing to do with Easycom.
There is no comparison of different toolkits at all here, only comparing differences of XMLSERVICE running on two different machines.

Let me rant a little bit more.

The first problem (that you didn't comment at all on your response), which as I mentioned is most likely an error on my part, is that we are running in local machine here (1st tier as you call it), but still we are for some reason ending up in QRWTSRVR jobs. If I have understood documentation on yips site correctly this shouldn't happen in 1st tier situation, it should only happen in 2nd tier calls. Like I said, this is most likely because of something I have done, that has messed things up, but I don't know what that something is. I thought you might have an idea what could cause the XMLSERVICE to be routed to QRWTSRVR instead of QSQSRVR in 1st tier program call situation.

About the other thing, yes obviously we could be using "startup program" to CHGLIBL the right library list for the job, but upkeep of such a programs is pure pain. That's why we have a working method, that was implemented long before there was any php toolkit in existence. The method is that with JDBC/ODBC/FTP/what-have-you external connections (integrations with other systems) we mostly won't use CHGLIBL programs/commands because it's much easier to manage changes when we only have to change the connecting user profile and/or the users job description (INLLIBL value) to set the correct library list for the job. If something with that particular integration changes, we can just change the job description instead of editing some cl source and compiling again and/or making changes to several different external systems using that integration. We also have couple of external integrations that do use CHGLIBL startup programs and like I said those are pain to manage compared to the ones that only use INLLIBL from the user's job description. Also same thing as with INLLIBL vs. CHGLIBL goes for INLASPGRP value of the job description vs. SETASPGRP command. We also use this method to get the correct iASP from user's job description as well, instead of using SETASPGRP command. I seem to remember many IBM documentation on the subject also specifically recommend using job description's to control initial asp group instead of the SETASPGRP command.

I could be very wrong here, but I just don't quite understand why 2nd tier would make the situation different here, since we are already in IBM i job anyway, and IBM i job should be able to use user, which has job description with initial library list and initial asp group. But if your earlier response means that this kind of behavior isn't possible in 2nd tier (QRWTSRVR) situation with XMLSERVICE, then that's fine and I accept that.

-Timo

[rangercairns]

Cool ... my mistake on "perceived" rant ... i am clearly geek not politician (unwanted politics on forum previously), but i am geek happy to help any user willing with issue to improve OS XMLSERVICE/Toolkit (hope you like the new "big data" record format, it seems to work fairly well). Anyway, don't have time to look into ... i doubt anyone working much Thanksgiving ... but will do next week.

Please any configuration and supporting data that you may find useful to help (maybe you already have) and we will try to figure it out.

Summary (i think):
-> WRKRDBDIRE 2-tier config to another IBM i ?
-> other IBM i is also using iASP (i use iASP my machine all time)?
-> why QW vs. QSQ?
-> why QW behave different?
-> what is your db2_connect (or toolkit) syntax for both/same issue (without password of course)?
-> db2_connect user profile has all the right stuff (LIBL)??
-> or do you also need special JOBD + PROFILE???

Wok around (right now):
-> CHGLIBL -- pain for you, ok i get it ...
-> Both XMLSERVICE and PHP Toolkit allow full override of SBMJOB of XMLSERVICE ...

Code: Select all

<sbmjob>SBMJOB CMD(CALL PGM(ZENDSVR/XMLSERVICE) PARM('/tmp/override'))</sbmjob>
...
Example:
<?php
require_once('ToolkitService.php');
$user = 'FREDFLIN';
$pw = 'MYPW';

$conn = ToolkitService::getInstance('*LOCAL', $user, $pw);

if (!$conn) {
   die('no toolkit connection');
}

$ipc = "/tmp/$user";

// Get library of toolkit for SBMJOB command
$toolkitLib = $conn->getToolkitServiceParam('XMLServiceLib');

// build complete SBMJOB command for full customization
$sbmjobCommand = "SBMJOB CMD(CALL PGM($toolkitLib/XMLSERVICE) PARM('$ipc')) JOB(FREDKITJOB) JOBD(ZENDSVR/ZSVR_JOBD) INLLIBL(*CURRENT)");

$conn->setToolkitServiceParams(array(
    'stateless'     => false,
    'InternalKey'   => $ipc,
    'sbmjobCommand' => $sbmjobCommand));

// Now if the job labeled with the requested InternalKey hasn't started yet, it will be submitted with the attributes indicated instead of the defaults from XMLSERVICE's plugconf1 or plugconf2.
$conn->pgmCall(.....);



[timo_karvinen]

Was busy with other work this week, I'll try to get you more details next week.

-Timo

[rangercairns]

This topic has morphed into a many types of connections discussion ... and ... well ... there are many possible connections. So, I updated a Yips wiki page with common combinations with respect iASP/LIBL, 1-tier/2-tier.

http://www.youngiprofessionals.com/wiki ... Connection

Does this answer your remaining questions???

== cut/paste ==
In general the user profile sets the LIBL/iASP for any connection from a PGM/SRVPGM/CMD point of view. However, DB2 supports both SQL naming (schema.table) and system naming (libl/table), where script must set "system naming" before LIBL will have any effect on DB2 unqualified objects look up. Some 2-tier drivers and PHP interfaces do not allow setting system naming as of this date, so LIBL becomes a called user program only attribute that is not stored procedure enabled.