I am not a VSE nor VM expert. ?I have a lot of communications experience. ?While you have AUTHORIZED the database client (on a VSE virtual machine) access to the database server via IUCV in another virtual machine, is the database client actually using IUCV?
I ask this question because the term APPLID as I understand it implies a VTAM based communication. ?In light of the fact that the server on VSE is being used, can you expand on the meaning of the term APPLID as used in the context of the ARISDIRD.A macro?
Harold Grovesteen
toggle quoted message
Show quoted text
On Wed, 2022-05-18 at 18:02 -0700, Jim Snellen wrote:
[Edited Message Follows]
i have a SQL database running on both VSE and VM.? I can access the VSE db server via a preprocessed, compiled, and cataloged batch program.? I can also access the VM db via ISQL or a COBOL program that has been preprocessed, compiled, and executed under CMS.? The documentation suggests I should be able to access the VM db server from a VSE batch program, however, all of my attempts have failed, and I keep getting data from the VSE db.? I will work on the online (CICS) access later but would welcome any suggestions or tips!
I am working with the sample tables on both systems.? The COBOL programs were provided by IBM to test the respective installations.? I have changed the last name on one of the sample tables (EMPLOYEE) on VM to determine if I am accessing the correct db when executing the VSE batch job which simply prints a telephone listing report. Since both databases are named SQLDBA, (somewhate confusing for me) I'm using the settings below:
FOR VM:
USER SQLMACH SQLMACH 64M 128M G?? ? ? ? ? ? ? ? ? ?
OPTION MAXCONN 26? ? ? ? ? ? ? ?
IUCV ALLOW? ? ? ? ? ? ? ? ? ? ??
IUCV *IDENT SQLDBA GLOBAL? ? ? ?
etc.
USER VSEVM VSE 256M 256M G?
IUCV SQLMACH?<<---- ?? allows IUCV communication to SQLMACH ??
etc.
FOR VSE:
SET XPCC TARGET SQLMACH TO APPCVM TARGET SQLDBA? ?<<---- specified during IPL
ARISDIRD.A DB2 for VSE Database Directory
??
*TPN? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ??
*|? ? APPLID? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ??
*|? ? |? ? ? ? SYSDEFAULT * = system default? ? ? ? ? ? ? ? ? ? ? ? ? ??
*|? ? |? ? ? ? |DBNAME? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ??
*|? ? |? ? ? ? ||? ? ? ? ? ? ? ? ? PDEFAULT? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
*|? ? |? ? ? ? ||? ? ? ? ? ? ? ? ? |? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ??
*|? ? |? ? ? ? ||? ? ? ? ? ? ? ? ? |? PRIVLEGE? ? ? ? ? ? ? ? ? ? ? ? ??
*|? ? |? ? ? ? ||? ? ? ? ? ? ? ? ? |? | SYSID? ? ? ? ? ? ? ? ? ? ? ? ? ?
*|? ? |? ? ? ? ||? ? ? ? ? ? ? ? ? |? | |? ? REMTPN? ? ? ? ? ? ? ? ? ? ?
*|? ? |? ? ? ? ||? ? ? ? ? ? ? ? ? |? | |? ? |? ? ? ? ? ? ? ? ? ? ? ? ??
*? ? ? ? ? ? 1? 1? ? ? ? ? ? ? ? 3 33 3 4? 4 4? ? ? ? ? ? ? ? ? ? ? ? ??
*2..._7......4_.7................4_67_9_1..4_6..........................
? ? ? SQLMACH? *SQLDBA? ? ? ? ? ? ? ? ? ? ? ? ? ??<<---- added to ARISDIRD macro? ? ? ? ? ? ? ? ? ? ?
?÷6DB SYSARI00? SQLDS? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
What am I missing and/or what is in error?
TITLE INCORRECT, SHOULD BE VSE & VM ISSUE
? ? ? ? ? ??
? ? ? ? ? ? ? ? ? ? ??
