开云体育

DOS/VSE & VM SQL Issue

Jim Snellen All Messages By This Member #318 Edited 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 ? ? ? ? ? ?? ? ? ? ? ? ? ? ? ? ? ??
Harold Grovesteen All Messages By This Member #319 开云体育 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 ? ? ? ? ? ?? ? ? ? ? ? ? ? ? ? ? ??
Jim Snellen All Messages By This Member #320 I’m not an expert either, in fact, most of my background is in applications. I only dabble in systems.? I really don’t know if IUCV is being used. Sorry, I cannot expand on APPLID in the ARISDIRD macro. ?I was hoping that someone out there has experience with using SQL in a VM/VSE environment. The settings I have specified is the result of pouring through the manuals.?
Harold Grovesteen All Messages By This Member #321 开云体育 I would suggest that because the local VSE database is being used, ?IUCV is definitely NOT being used. ?Whether it CAN be used is an unanswered question. ?Or how to enable it within the database client implementation. Harold Grovesteen toggle quoted message Show quoted text On Fri, 2022-05-20 at 05:48 -0700, Jim Snellen wrote: I’m not an expert either, in fact, most of my background is in applications. I only dabble in systems.? I really don’t know if IUCV is being used. Sorry, I cannot expand on APPLID in the ARISDIRD macro. ?I was hoping that someone out there has experience with using SQL in a VM/VSE environment. The settings I have specified is the result of pouring through the manuals.?

Previous Topic Next Topic