Re: IBM Solutions for leveraging cloud object storage on z/OS
Perfect - much easier to read. On 12/15/2022 1:47 PM, Glenn Wilcock wrote: Hi Tom, you're not alone! I've added an attachment of the pdf at the same link. Viewing the pdf in full-screen mode gives you the same navigation, but removes all of the animation so that you can go at your own speed... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Transmitting SMF records
On 16/12/2022 1:43 am, Gary Weinhold wrote: As an alternative, it wouldn't seem very difficult to create a utility to read the FTPed data (received as a sequential file with an arbitrary record length) and reformat the data to write a VB(S) file. It is not difficult. The biggest problem is that by default FTP strips the RDW, which makes variable length binary data unusable. The solution to that problem is to use the SITE RDW option for the download. I wrote a Java program to read/write z/OS data in GZIP format to get around the various problems. You can: - gzip VB(S) into a FB dataset on z/OS, download the data and unzip on a PC - download VB(S) data using BINARY and SITE RDW options, gzip the data on the PC, upload to a FB dataset then uncompress to a VB(S) dataset. The program is available here: https://github.com/BlackHillSoftware/z-java/tree/master/java/compress -- Andrew Rowley Black Hill Software -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: IBM Solutions for leveraging cloud object storage on z/OS
Hi Tom, you're not alone! I've added an attachment of the pdf at the same link. Viewing the pdf in full-screen mode gives you the same navigation, but removes all of the animation so that you can go at your own speed... -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: DB2 V12 DB2 connect v9.5 problem
A good explanation is in apar PH08482 https://www.ibm.com/support/pages/apar/PH08482 On Thu, Dec 15, 2022 at 8:39 PM Binyamin Dissen wrote: > Perhaps I am missing something, but the V12R1M500 is the BIND APPLCOMPAT on > the mainframe. The client doesn't need any V12 services (or V9, for that > matter). > > How can I bind the PACKAGE so that the client side APPLCOMPAT (of *) is > acceptable? > > Or how can I tell IBM DB2 Client 9.5 to set APPLCOMPAT? Don't see any > obvious > option or command to set it. > > On Thu, 15 Dec 2022 08:50:53 +1100 Attila Fogarasi > wrote: > > :>Normally this is due to a back-level client driver which doesn't support > :>M502. Installing a new driver on the client system is the usual remedy > if > :>M502 is really needed (function used in the applications). Otherwise you > :>can rebind the package specifying V12R1M500 which should work with the > :>existing back-level driver. > :> > :>On Wed, Dec 14, 2022 at 9:42 PM Binyamin Dissen < > bdis...@dissensoftware.com> > :>wrote: > :> > :>> I am getting > :>> > :>> DSNL076I -DBCG DSNLXSVC DDF CONNECTION REJECTED DUE 794 > :>> TO INCOMPATIBLE APPLCOMPAT VALUES. > :>>LUWID=P3EBC7B8.H043.DC8D7A13DC85 > :>>CLIENTAPPLCOMPAT=* > :>>PACKAGEAPPLCOMPAT=V12R1M502 > :>>PACKAGE=NULLID.SQLC2G13.41414141414E4758 > :>> > :>> I cannot figure out how to set the client level APPLCOMPAT or bind the > :>> nullid > :>> package to match. > > -- > Binyamin Dissen > http://www.dissensoftware.com > > Director, Dissen Software, Bar & Grill - Israel > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: IBM Solutions for leveraging cloud object storage on z/OS
Thanks, I downloaded with no problems. But when I run it here, the text appears slowly on the screen. I'm kind of impatient :) so I stopped reading after the second screen. Is there a button I can push that will show me all the text on a screen without waiting? On 12/15/2022 11:26 AM, Glenn Wilcock wrote: I often get asked what solutions are available to leverage cloud object storage solutions on z/OS. I'm working on a slideshow introduction to the solutions that IBM offers. I plan to add a voice-over and some navigational enhancements, but wanted to share what I have so far. Please feel free to reach out for follow-up discussions. (I'm taking the last 2 weeks of the year off, so there will be a delay in my response over the next 2 weeks). Happy Holidays and New Year! (The slideshow is stored on the IBM Community. When I tested the link, it didn't require a log on). https://community.ibm.com/community/user/ibmz-and-linuxone/viewdocument/zos-cloud-object-storage-solutions?CommunityKey=3c6c69c1-abde-4ee6-b603-19ef14942e8f=librarydocuments -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: IBM Solutions for leveraging cloud object storage on z/OS
Thank you Greg, Happy Holidays to you Carmen On 12/15/2022 1:26 PM, Glenn Wilcock wrote: I often get asked what solutions are available to leverage cloud object storage solutions on z/OS. I'm working on a slideshow introduction to the solutions that IBM offers. I plan to add a voice-over and some navigational enhancements, but wanted to share what I have so far. Please feel free to reach out for follow-up discussions. (I'm taking the last 2 weeks of the year off, so there will be a delay in my response over the next 2 weeks). Happy Holidays and New Year! (The slideshow is stored on the IBM Community. When I tested the link, it didn't require a log on). https://community.ibm.com/community/user/ibmz-and-linuxone/viewdocument/zos-cloud-object-storage-solutions?CommunityKey=3c6c69c1-abde-4ee6-b603-19ef14942e8f=librarydocuments -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Carmen -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
IBM Solutions for leveraging cloud object storage on z/OS
I often get asked what solutions are available to leverage cloud object storage solutions on z/OS. I'm working on a slideshow introduction to the solutions that IBM offers. I plan to add a voice-over and some navigational enhancements, but wanted to share what I have so far. Please feel free to reach out for follow-up discussions. (I'm taking the last 2 weeks of the year off, so there will be a delay in my response over the next 2 weeks). Happy Holidays and New Year! (The slideshow is stored on the IBM Community. When I tested the link, it didn't require a log on). https://community.ibm.com/community/user/ibmz-and-linuxone/viewdocument/zos-cloud-object-storage-solutions?CommunityKey=3c6c69c1-abde-4ee6-b603-19ef14942e8f=librarydocuments -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Transmitting SMF records
>From Barry Merrill : >... >But if the destination is for ASCII and SAS, you can use IEBGENER to create a >copy of >the data, on z/OS, but using RECFM=U, which ftp can't muck-up, and SAS on >ASCII processes that data using RECFM=S370VBS, since the file has the BDW and >RDW, so the downloaded file >RECFM=U file can be read directly by SAS. > > // EXEC PGM=IEBGENER > //SYSUT1 DD DSN=YOUR.VB.FILE,DISP=SHR,RECFM=U,BLKSIZE=32760 > ... I have tried to shortcut such a process at this point by: // EXEC PGM=FTP //SYSUT1 DD DSN=YOUR.VB.FILE,DISP=SHR,RECFM=U,BLKSIZE=32760 //INPUR DD * ... binary put DD:SYSUT1 ... ... Only to be dismayed that FTP apparently reads the DSCB and lets that dominate attributes coded on the DD statement. This is a significant transgression of MVS conventions. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Transmitting SMF records
On Thu, 15 Dec 2022 15:31:31 +, Seymour J Metz wrote: >There are several facilities for encoding variable-length recrds into FB, >e.g., XMIT. A bit kludgy, but it works. > Alas, one needs to operate at both the sending and receiving ends because z/OS sort lacks anything such as a QUOTE SITE XMIT mode. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Problem with DFSORT SUM FIELDS
Hi Kolusu, Forget it, please. I was missing a "," at the end of the line. Now it ran just fine. Regards, Jack On Thu, 15 Dec 2022 at 16:58, Sri h Kolusu wrote: > >> It is giving an error that is baffling me: > > Jack, > > Did you define the symbols correctly ? I changed the SYMNAMES to add the > temp fields. > > // DD * > SKIP,2 > TMP-DCVVLCAP,*,8,BI > TMP-DCVVLCAP1,=,4,BI > TMP-DCVVLCAP2,*,4,BI > TMP-DCVALLOC,*,8,BI > TMP-DCVALLOC1,=,4,BI > TMP-DCVALLOC2,*,4,BI > > Thanks, > Kolusu > DFSORT Development > IBM Corporation > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Problem with DFSORT SUM FIELDS
Sorry Kolusu, I should have sent all the JCL and SORT control cards: //SYMNAMES DD DISP=SHR,DSN=(HEADER) // DD DISP=SHR,DSN=(TYPED) // DD DISP=SHR,DSN=(TYPEV) // DD * TMP-DCVVLCAP,*,8,BI TMP-DCVVLCAP1,=,4,BI TMP-DCVVLCAP2,*,4,BI TMP-DCVALLOC,*,8,BI TMP-DCVALLOC1,=,4,BI TMP-DCVALLOC2,*,4,BI /* //SYSINDD * OPTION VLSHRT,VLSCMP,DYNALLOC=(,4) INREC OVERLAY=(TMP-DCVVLCAP:8Z, TMP-DCVVLCAP2:DCVVLCAP TMP-DCVALLOC:8Z, TMP-DCVALLOC2:DCVALLOC) SORT FIELDS=(DCVSGTCL,A) SUM FIELDS=(TMP-DCVVLCAP, TMP-DCVALLOC) OUTREC BUILD=(1,4, DCVSGTCL, X, TMP-DCVVLCAP,TO=ZD,LENGTH=16, X, TMP-DCVALLOC,TO=ZD,LENGTH=16) /* the sort sysout error: ICE280I 1 ORIGINAL STATEMENTS FROM SYSINFOLLOW OPTION VLSHRT,VLSCMP,DYNALLOC=(,4) INREC OVERLAY=(TMP-DCVVLCAP:8Z, TMP-DCVVLCAP2:DCVVLCAP TMP-DCVALLOC:8Z, TMP-DCVALLOC2:DCVALLOC) SORT FIELDS=(DCVSGTCL,A) SUM FIELDS=(TMP-DCVVLCAP, TMP-DCVALLOC) OUTREC BUILD=(1,4, DCVSGTCL, X, TMP-DCVVLCAP,TO=ZD,LENGTH=16, X, TMP-DCVALLOC,TO=ZD,LENGTH=16) ICE282I 0 PERFORMING SYMBOL SUBSTITUTION AS NEEDED INREC OVERLAY=(TMP-DCVVLCAP:8Z, TMP-DCVVLCAP2:DCVVLCAP $ ICE805I 1 JOBNAME: SJ81424D , STEPNAME: SORT003 ICE802I 0 BLOCKSET TECHNIQUE IN CONTROL ICE283A 0 SYMBOL, SYNTAX OR DELIMITER ERROR ICE287A 0 ONE OR MORE ERRORS ENCOUNTERED DURING SYMBOL SUBSTITUTION ICE751I 0 C5-I90068 E7-I76949 ICE052I 3 END OF DFSORT As I said in in my previous email, the "$" sing is bellow de "D" after the ":", and that baffles me because that particular symbol is defined in the TYPEV copybook Regards, Jack On Thu, 15 Dec 2022 at 16:58, Sri h Kolusu wrote: > >> It is giving an error that is baffling me: > > Jack, > > Did you define the symbols correctly ? I changed the SYMNAMES to add the > temp fields. > > // DD * > SKIP,2 > TMP-DCVVLCAP,*,8,BI > TMP-DCVVLCAP1,=,4,BI > TMP-DCVVLCAP2,*,4,BI > TMP-DCVALLOC,*,8,BI > TMP-DCVALLOC1,=,4,BI > TMP-DCVALLOC2,*,4,BI > > Thanks, > Kolusu > DFSORT Development > IBM Corporation > > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Problem with DFSORT SUM FIELDS
>> It is giving an error that is baffling me: Jack, Did you define the symbols correctly ? I changed the SYMNAMES to add the temp fields. // DD * SKIP,2 TMP-DCVVLCAP,*,8,BI TMP-DCVVLCAP1,=,4,BI TMP-DCVVLCAP2,*,4,BI TMP-DCVALLOC,*,8,BI TMP-DCVALLOC1,=,4,BI TMP-DCVALLOC2,*,4,BI Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Problem with DFSORT SUM FIELDS
Hi Kolusu, Thank you for your quick answer. As it would be expected I had the ICE152I 0 OVERFLOW DURING SUMMATION - RC=0 message. I did not think of looking for error messages due to the final RC(0). I ran the SORT with your suggested improvements. It is giving an error that is baffling me: ICE282I 0 PERFORMING SYMBOL SUBSTITUTION AS NEEDED INREC OVERLAY=(TMP-DCVVLCAP:8Z, TMP-DCVVLCAP2:DCVVLCAP $ he "$" sign is below the "D" after the ":" Can you please help? Thanks Jack On Thu, 15 Dec 2022 at 16:05, Sri h Kolusu wrote: > > >> As you can see, I have multiple records for storage group SGDBPR and > SGPBBA01. Any ideas as what may be causing this? > > Jack, > > You need to check your joblog to see if you received ICE152I message which > indicates that there is an OVERFLOW of the summation fields. > > ICE152I 0 OVERFLOW DURING SUMMATION - RC=0 > > DCVVLCAP and DCVALLOC are both 4-byte binary fields and when you some sum > them, it might exceed the value a 4 byte binary can fit into. So, you need > to pad binary zeros and sum it as a bigger number. > > Since you are using Symbols , I added the temp fields at the end and SUM > those temp fields > > //SYMNAMES DD DISP=SHR,DSN=(HEADER) > // DD DISP=SHR,DSN=(TYPED) > // DD DISP=SHR,DSN=(TYPEV) > // DD * > SKIP,2 > TMP-DCVVLCAP,*,8,BI > TMP-DCVVLCAP1,=,4,BI > TMP-DCVVLCAP2,*,4,BI > TMP-DCVALLOC,*,8,BI > TMP-DCVALLOC1,=,4,BI > TMP-DCVALLOC2,*,4,BI > > > //SYSINDD * > OPTION VLSHRT,VLSCMP,DYNALLOC=(,4) > >INREC OVERLAY=(TMP-DCVVLCAP:8Z, > TMP-DCVVLCAP2:DCVVLCAP > TMP-DCVALLOC:8Z, > TMP-DCVALLOC2:DCVALLOC) > > SORT FIELDS=(DCVSGTCL,A) > >SUM FIELDS=(TMP-DCVVLCAP, >TMP-DCVALLOC) > > OUTREC BUILD=(1,4, >DCVSGTCL, >X, >TMP-DCVVLCAP,TO=ZD,LENGTH=16, >X, >TMP-DCVALLOC,TO=ZD,LENGTH=16) > /* > > > Thanks, > Kolusu > DFSORT Development > IBM Corporation > > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Problem with DFSORT SUM FIELDS
>> As you can see, I have multiple records for storage group SGDBPR and >> SGPBBA01. Any ideas as what may be causing this? Jack, You need to check your joblog to see if you received ICE152I message which indicates that there is an OVERFLOW of the summation fields. ICE152I 0 OVERFLOW DURING SUMMATION - RC=0 DCVVLCAP and DCVALLOC are both 4-byte binary fields and when you some sum them, it might exceed the value a 4 byte binary can fit into. So, you need to pad binary zeros and sum it as a bigger number. Since you are using Symbols , I added the temp fields at the end and SUM those temp fields //SYMNAMES DD DISP=SHR,DSN=(HEADER) // DD DISP=SHR,DSN=(TYPED) // DD DISP=SHR,DSN=(TYPEV) // DD * SKIP,2 TMP-DCVVLCAP,*,8,BI TMP-DCVVLCAP1,=,4,BI TMP-DCVVLCAP2,*,4,BI TMP-DCVALLOC,*,8,BI TMP-DCVALLOC1,=,4,BI TMP-DCVALLOC2,*,4,BI //SYSINDD * OPTION VLSHRT,VLSCMP,DYNALLOC=(,4) INREC OVERLAY=(TMP-DCVVLCAP:8Z, TMP-DCVVLCAP2:DCVVLCAP TMP-DCVALLOC:8Z, TMP-DCVALLOC2:DCVALLOC) SORT FIELDS=(DCVSGTCL,A) SUM FIELDS=(TMP-DCVVLCAP, TMP-DCVALLOC) OUTREC BUILD=(1,4, DCVSGTCL, X, TMP-DCVVLCAP,TO=ZD,LENGTH=16, X, TMP-DCVALLOC,TO=ZD,LENGTH=16) /* Thanks, Kolusu DFSORT Development IBM Corporation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Transmitting SMF records
From Barry Merrill : My mxg.com email server company, RACKSPACE, took a Ransomeware attack and I'm unable to originate mail from ba...@mxg.com, although I am receiving forwards. Can you post this to the IBM-MAIN track for me. The problem with moving SMF records with ftp is that whenever ftp sees RECFM=V/VB/VBS, it strips the BDW and RDW fields and only sends the data in those records, which is a totally useless file. Terse works, for z/OS to z/OS, and also works sending to ASCII, where you can using the UNTERSE.EXE program that Cheryl Watson provides. to recreate the original VBS file. But if the destination is for ASCII and SAS, you can use IEBGENER to create a copy of the data, on z/OS, but using RECFM=U, which ftp can't muck-up, and SAS on ASCII processes that data using RECFM=S370VBS, since the file has the BDW and RDW, so the downloaded file RECFM=U file can be read directly by SAS. // EXEC PGM=IEBGENER //SYSUT1 DD DSN=YOUR.VB.FILE,DISP=SHR,RECFM=U,BLKSIZE=32760 //SYSUT2 DD DSN=YOUR.NEW.RECFMU,DISP=(,CATLG),RECFM=U, // BLKSIZE=32760,UNIT=SYSDA,SPACE=(CYL,(50,50)) //SYSIN DD DUMMY And since the RECFM=U file has the BDW and RDW, it could be processed on z/OS to recreate the original VBS data. Merrilly Christmas, Barry Merrill -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Transmitting SMF records
On Thu, 15 Dec 2022 15:24:04 +, Pommier, Rex wrote: >What I remember from a discussion long ago was that the reason a VBS dataset >can't be put back together again is that when the VBS dataset is sent to a >Windows intermediary, some of the binary metadata defining the records and >blocks is lost by the Windows side, making it impossible to recreate the VBS >on the other end. Whether this is actually true or not, that's what I recall. > Going straight z/OS to z/OS that metadata is retained. > In another experiment with the RDW option a get from MVS to desktop put RDW images in the data stream. But a put back to MVS resulted in double RDWs in the MVS data set. It appears that coders misunderstood the intent of the designers. And MVS-to-MVS with STRU R caused segments of a VBS data set to be broken into individual records. IBM could have done better. Any one else would have done better. -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Transmitting SMF records
On Thu, 15 Dec 2022 14:43:48 +, Gary Weinhold wrote: >I'm glad there was a solution. > >But the underlying problem seems to be that z/OS FTP appears to be limited to >processing a binary (image) transfer as a stream of bytes unless the transfer >is between a z/OS client and z/OS server. ... > Not entirely true. In days of yore, from an MVS server and a desktop client, I have done such as: binary quote site type e quote site mode b MVS encapsulates the data by its conventions and the desktop sees a simple "stream of bytes". Reversing the process with a "put" with a diffenent MVS server and the desktop client correctly reconstitutes the data. Or, a desktop filter could be written to decode the data stream. Likewise, the WUSTL FTP server performed conversions on-the-fly, such as zipping a directory. z/OS could do better than it does, such as AMATERSE on-the-fly with a SITE command. Do the Dovetailed or Rocket products do something similar? -- gil -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Problem with DFSORT SUM FIELDS
Hi, I am trying to use DFSORT to summarize the space on a few STORAGE GROUPS. The INPUT is a file with all the DCOLLECT TYPE "V" records. I am sorting it by the storage group name, and using for SUM FIELDS the "TOTAL CAPACITY OF VOL" and "ALLOCATED SPACE ON VOL": //SYMNAMES DD DISP=SHR,DSN=(HEADER) // DD DISP=SHR,DSN=(TYPED) // DD DISP=SHR,DSN=(TYPEV) // DD * /* //SYSINDD * OPTION VLSHRT,VLSCMP,DYNALLOC=(,4) SORT FIELDS=(DCVSGTCL,A) SUM FIELDS=(DCVVLCAP, DCVALLOC) OUTREC BUILD=(1,4, DCVSGTCL, X, DCVVLCAP,TO=ZD,LENGTH=12, X, DCVALLOC,TO=ZD,LENGTH=12) /* SGDBPR 004269156403 003922234851 SGDBPR 004291119225 003956540903 SGDBPR 003921254707 003540881521 SGPBBA01 004270725195 003604173686 SGPBBA01 000489457431 000415088205 SGPBSLF1 000794845384 000618058380 SGPCMN01 000946545810 000703252143 As you can see, I have multiple records for storage group SGDBPR and SGPBBA01. Any ideas as what may be causing this? Regards, Jack -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Transmitting SMF records
There are several facilities for encoding variable-length recrds into FB, e.g., XMIT. A bit kludgy, but it works. -- Shmuel (Seymour J.) Metz http://mason.gmu.edu/~smetz3 From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Gary Weinhold [weinh...@dkl.com] Sent: Thursday, December 15, 2022 9:43 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Transmitting SMF records I'm glad there was a solution. But the underlying problem seems to be that z/OS FTP appears to be limited to processing a binary (image) transfer as a stream of bytes unless the transfer is between a z/OS client and z/OS server. IBM RECFM of VB and VBS seem to be quite well defined and I don't know why, if the receiving z/OS FTP is informed that the data stream is actually VB(S) format, either by SITE/LOCSITE FTP commands or by the DCB of a preallocated output dataset, it can't invoke the same routines that it would if the sender was a z/OS system. As an alternative, it wouldn't seem very difficult to create a utility to read the FTPed data (received as a sequential file with an arbitrary record length) and reformat the data to write a VB(S) file. I've known of windows-based utilities that process FTPed SMF data (raw or tersed) so the technical knowledge is out there. Date:Wed, 14 Dec 2022 13:22:27 -0600 From:Boesel Guillaume Subject: Re: [EXTERNAL] Re: Transmitting SMF records Hi Rex, Great. You are right, tersing file from tape to tape works well. It took around 80-90 MSU during an hour for just one file but it worked. Hoping that Ituriel will be able to read this file. Regards and thanks ! Gary Weinhold Senior Application Architect DATAKINETICS | Data Performance & Optimization Phone:+1.613.523.5500 x216 Email: weinh...@dkl.com Visit us online at http://secure-web.cisco.com/1vK3ImFMcgJFz1-podVzEvvVNPbvWjVSieyjkh6kLxBdI18iG5QnqSs8i3kvg0VuH7204uOmMnKxzNWjytZKTENLkVxzqlS6qikvi5yyFIoZCAoeXpVZj5oxOvcUQ3Ser-p1bEnMNTL9HSqHk87DLceE1T02i4JoEtLUqRh-ODRJC2ht43WZl0yLIFPIRwB34PCCKDUw30GrIIxH60SKjQjUQPjlTkmBmKsMJ4ecTK6lrN7uRrBJd5ldQrR3ng7w_T4uwNU_2lim1m5EAEPW1iWz7pc-f38LXw6hw_5oBwp4lS0xjTkyjxSmvz40O8fQljIGe_yml36Zm4s7dRvd4Mtp8Ufji1epM_WSXVoZJ-_wkJRyjjMTjGaoW5QBT-9890J4jC7Ric1OtjYH1N8HRdseY5eoVBhZAd0rmIRykJumh7RV4I3qACvxREuMo4gvP/http%3A%2F%2Fwww.DKL.com E-mail Notification: The information contained in this email and any attachments is confidential and may be subject to copyright or other intellectual property protection. If you are not the intended recipient, you are not authorized to use or disclose this information, and we request that you notify us by reply mail or telephone and delete the original message from your mail system. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Transmitting SMF records
Doesn't XMIT/RECEIVE handle VBS in both directions? I thought it did. Peter -Original Message- From: IBM Mainframe Discussion List On Behalf Of Pommier, Rex Sent: Thursday, December 15, 2022 10:24 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Transmitting SMF records What I remember from a discussion long ago was that the reason a VBS dataset can't be put back together again is that when the VBS dataset is sent to a Windows intermediary, some of the binary metadata defining the records and blocks is lost by the Windows side, making it impossible to recreate the VBS on the other end. Whether this is actually true or not, that's what I recall. Going straight z/OS to z/OS that metadata is retained. Rex -Original Message- From: IBM Mainframe Discussion List On Behalf Of Gary Weinhold Sent: Thursday, December 15, 2022 8:44 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: Transmitting SMF records I'm glad there was a solution. But the underlying problem seems to be that z/OS FTP appears to be limited to processing a binary (image) transfer as a stream of bytes unless the transfer is between a z/OS client and z/OS server. IBM RECFM of VB and VBS seem to be quite well defined and I don't know why, if the receiving z/OS FTP is informed that the data stream is actually VB(S) format, either by SITE/LOCSITE FTP commands or by the DCB of a preallocated output dataset, it can't invoke the same routines that it would if the sender was a z/OS system. As an alternative, it wouldn't seem very difficult to create a utility to read the FTPed data (received as a sequential file with an arbitrary record length) and reformat the data to write a VB(S) file. I've known of windows-based utilities that process FTPed SMF data (raw or tersed) so the technical knowledge is out there. Date:Wed, 14 Dec 2022 13:22:27 -0600 From:Boesel Guillaume Subject: Re: [EXTERNAL] Re: Transmitting SMF records Hi Rex, Great. You are right, tersing file from tape to tape works well. It took around 80-90 MSU during an hour for just one file but it worked. Hoping that Ituriel will be able to read this file. Regards and thanks ! Gary Weinhold Senior Application Architect DATAKINETICS | Data Performance & Optimization Phone:+1.613.523.5500 x216 Email: weinh...@dkl.com -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Transmitting SMF records
What I remember from a discussion long ago was that the reason a VBS dataset can't be put back together again is that when the VBS dataset is sent to a Windows intermediary, some of the binary metadata defining the records and blocks is lost by the Windows side, making it impossible to recreate the VBS on the other end. Whether this is actually true or not, that's what I recall. Going straight z/OS to z/OS that metadata is retained. Rex -Original Message- From: IBM Mainframe Discussion List On Behalf Of Gary Weinhold Sent: Thursday, December 15, 2022 8:44 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: [EXTERNAL] Re: Transmitting SMF records I'm glad there was a solution. But the underlying problem seems to be that z/OS FTP appears to be limited to processing a binary (image) transfer as a stream of bytes unless the transfer is between a z/OS client and z/OS server. IBM RECFM of VB and VBS seem to be quite well defined and I don't know why, if the receiving z/OS FTP is informed that the data stream is actually VB(S) format, either by SITE/LOCSITE FTP commands or by the DCB of a preallocated output dataset, it can't invoke the same routines that it would if the sender was a z/OS system. As an alternative, it wouldn't seem very difficult to create a utility to read the FTPed data (received as a sequential file with an arbitrary record length) and reformat the data to write a VB(S) file. I've known of windows-based utilities that process FTPed SMF data (raw or tersed) so the technical knowledge is out there. Date:Wed, 14 Dec 2022 13:22:27 -0600 From:Boesel Guillaume Subject: Re: [EXTERNAL] Re: Transmitting SMF records Hi Rex, Great. You are right, tersing file from tape to tape works well. It took around 80-90 MSU during an hour for just one file but it worked. Hoping that Ituriel will be able to read this file. Regards and thanks ! Gary Weinhold Senior Application Architect DATAKINETICS | Data Performance & Optimization Phone:+1.613.523.5500 x216 Email: weinh...@dkl.com Visit us online at https://urldefense.com/v3/__http://www.DKL.com__;!!KjMRP1Ixj6eLE0Fj!t94elsOrEvIcYpn4y0psf9Eq7Ucy2y6VjZr7S8ZoEs891YhFSJHV31zfn4u6nrJDbihyksQwsobJxQ0_zQ$ E-mail Notification: The information contained in this email and any attachments is confidential and may be subject to copyright or other intellectual property protection. If you are not the intended recipient, you are not authorized to use or disclose this information, and we request that you notify us by reply mail or telephone and delete the original message from your mail system. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- The information contained in this message is confidential, protected from disclosure and may be legally privileged. If the reader of this message is not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any disclosure, distribution, copying, or any action taken or action omitted in reliance on it, is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by replying to this message and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Transmitting SMF records
I'm glad there was a solution. But the underlying problem seems to be that z/OS FTP appears to be limited to processing a binary (image) transfer as a stream of bytes unless the transfer is between a z/OS client and z/OS server. IBM RECFM of VB and VBS seem to be quite well defined and I don't know why, if the receiving z/OS FTP is informed that the data stream is actually VB(S) format, either by SITE/LOCSITE FTP commands or by the DCB of a preallocated output dataset, it can't invoke the same routines that it would if the sender was a z/OS system. As an alternative, it wouldn't seem very difficult to create a utility to read the FTPed data (received as a sequential file with an arbitrary record length) and reformat the data to write a VB(S) file. I've known of windows-based utilities that process FTPed SMF data (raw or tersed) so the technical knowledge is out there. Date:Wed, 14 Dec 2022 13:22:27 -0600 From:Boesel Guillaume Subject: Re: [EXTERNAL] Re: Transmitting SMF records Hi Rex, Great. You are right, tersing file from tape to tape works well. It took around 80-90 MSU during an hour for just one file but it worked. Hoping that Ituriel will be able to read this file. Regards and thanks ! Gary Weinhold Senior Application Architect DATAKINETICS | Data Performance & Optimization Phone:+1.613.523.5500 x216 Email: weinh...@dkl.com Visit us online at www.DKL.com E-mail Notification: The information contained in this email and any attachments is confidential and may be subject to copyright or other intellectual property protection. If you are not the intended recipient, you are not authorized to use or disclose this information, and we request that you notify us by reply mail or telephone and delete the original message from your mail system. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: DB2 V12 DB2 connect v9.5 problem
We just went from DB2 v9 to v12 M500. Had to upgrade clients to 11.5. Doug . On Dec 15, 2022, at 08:35, Clark, Kevin wrote: Looks like you'll need to be at least V11.1.??? for Data Sever Client https://www.ibm.com/docs/en/db2-for-zos/12?topic=aclid-v12r1mnnn-application-compatibility-levels-data-server-clients-drivers V9.5 reach EOS many years ago. We just ran a scan to locate software version and still have a few 9.5 versions out there after upgrading to V11.5 Client. It's worth the effort to upgrade everywhere as soon as possible , to avoid these type of road blocks going forward with DB2 upgrades Kevin -Original Message- From: IBM Mainframe Discussion List On Behalf Of Binyamin Dissen Sent: Thursday, December 15, 2022 4:39 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DB2 V12 DB2 connect v9.5 problem EXTERNAL EMAIL – USE CAUTION: This email is from an EXTERNAL source. Ensure you trust this sender before clicking on any links or attachments. Perhaps I am missing something, but the V12R1M500 is the BIND APPLCOMPAT on the mainframe. The client doesn't need any V12 services (or V9, for that matter). How can I bind the PACKAGE so that the client side APPLCOMPAT (of *) is acceptable? Or how can I tell IBM DB2 Client 9.5 to set APPLCOMPAT? Don't see any obvious option or command to set it. On Thu, 15 Dec 2022 08:50:53 +1100 Attila Fogarasi wrote: :>Normally this is due to a back-level client driver which doesn't support :>M502. Installing a new driver on the client system is the usual remedy if :>M502 is really needed (function used in the applications). Otherwise you :>can rebind the package specifying V12R1M500 which should work with the :>existing back-level driver. :> :>On Wed, Dec 14, 2022 at 9:42 PM Binyamin Dissen :>wrote: :> :>> I am getting :>> :>> DSNL076I -DBCG DSNLXSVC DDF CONNECTION REJECTED DUE 794 :>> TO INCOMPATIBLE APPLCOMPAT VALUES. :>>LUWID=P3EBC7B8.H043.DC8D7A13DC85 :>>CLIENTAPPLCOMPAT=* :>>PACKAGEAPPLCOMPAT=V12R1M502 :>>PACKAGE=NULLID.SQLC2G13.41414141414E4758 :>> :>> I cannot figure out how to set the client level APPLCOMPAT or bind the :>> nullid :>> package to match. -- Binyamin Dissen https://urldefense.com/v3/__http://www.dissensoftware.com__;!!EwdynJtshnZ7iu3ntw!mBf5f2W_JigNcVHMOLqhTM86-k5x_toZh3jvLl_OuUmDUFrK7qXje1qQMsDdzasPcfYf2S5d4w6SQFc1sXoaetg$ Director, Dissen Software, Bar & Grill - Israel -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN *** Unauthorized interception of this communication could be a violation of Federal and State Law. This communication and any files transmitted with it are confidential and may contain protected health information. This communication is solely for the use of the person or entity to whom it was addressed. If you are not the intended recipient, any use, distribution, printing or acting in reliance on the contents of this message is strictly prohibited. If you have received this message in error, please notify the sender and destroy any and all copies. Thank you. ATENCIÓN: Si habla español, tiene a su disposición servicios gratuitos de asistencia lingüística. Llame al 855-258-6518 注意：如果您使用繁體中文，您可以免費獲得語言援助服務。請致電 855-258-6518 CareFirst BlueCross BlueShield, CareFirst BlueChoice, Inc. and all of their corporate affiliates comply with applicable federal civil rights laws and do not discriminate on the basis of race, color, national origin, age, disability or sex. *** -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: DB2 V12 DB2 connect v9.5 problem
Looks like you'll need to be at least V11.1.??? for Data Sever Client https://www.ibm.com/docs/en/db2-for-zos/12?topic=aclid-v12r1mnnn-application-compatibility-levels-data-server-clients-drivers V9.5 reach EOS many years ago. We just ran a scan to locate software version and still have a few 9.5 versions out there after upgrading to V11.5 Client. It's worth the effort to upgrade everywhere as soon as possible , to avoid these type of road blocks going forward with DB2 upgrades Kevin -Original Message- From: IBM Mainframe Discussion List On Behalf Of Binyamin Dissen Sent: Thursday, December 15, 2022 4:39 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DB2 V12 DB2 connect v9.5 problem EXTERNAL EMAIL – USE CAUTION: This email is from an EXTERNAL source. Ensure you trust this sender before clicking on any links or attachments. Perhaps I am missing something, but the V12R1M500 is the BIND APPLCOMPAT on the mainframe. The client doesn't need any V12 services (or V9, for that matter). How can I bind the PACKAGE so that the client side APPLCOMPAT (of *) is acceptable? Or how can I tell IBM DB2 Client 9.5 to set APPLCOMPAT? Don't see any obvious option or command to set it. On Thu, 15 Dec 2022 08:50:53 +1100 Attila Fogarasi wrote: :>Normally this is due to a back-level client driver which doesn't support :>M502. Installing a new driver on the client system is the usual remedy if :>M502 is really needed (function used in the applications). Otherwise you :>can rebind the package specifying V12R1M500 which should work with the :>existing back-level driver. :> :>On Wed, Dec 14, 2022 at 9:42 PM Binyamin Dissen :>wrote: :> :>> I am getting :>> :>> DSNL076I -DBCG DSNLXSVC DDF CONNECTION REJECTED DUE 794 :>> TO INCOMPATIBLE APPLCOMPAT VALUES. :>>LUWID=P3EBC7B8.H043.DC8D7A13DC85 :>>CLIENTAPPLCOMPAT=* :>>PACKAGEAPPLCOMPAT=V12R1M502 :>>PACKAGE=NULLID.SQLC2G13.41414141414E4758 :>> :>> I cannot figure out how to set the client level APPLCOMPAT or bind the :>> nullid :>> package to match. -- Binyamin Dissen https://urldefense.com/v3/__http://www.dissensoftware.com__;!!EwdynJtshnZ7iu3ntw!mBf5f2W_JigNcVHMOLqhTM86-k5x_toZh3jvLl_OuUmDUFrK7qXje1qQMsDdzasPcfYf2S5d4w6SQFc1sXoaetg$ Director, Dissen Software, Bar & Grill - Israel -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN *** Unauthorized interception of this communication could be a violation of Federal and State Law. This communication and any files transmitted with it are confidential and may contain protected health information. This communication is solely for the use of the person or entity to whom it was addressed. If you are not the intended recipient, any use, distribution, printing or acting in reliance on the contents of this message is strictly prohibited. If you have received this message in error, please notify the sender and destroy any and all copies. Thank you. ATENCIÓN: Si habla español, tiene a su disposición servicios gratuitos de asistencia lingüística. Llame al 855-258-6518 注意：如果您使用繁體中文，您可以免費獲得語言援助服務。請致電 855-258-6518 CareFirst BlueCross BlueShield, CareFirst BlueChoice, Inc. and all of their corporate affiliates comply with applicable federal civil rights laws and do not discriminate on the basis of race, color, national origin, age, disability or sex. *** -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Steve Myers whereabouts
Steve WAS a regular on ibmmainframes.com for a long time, I worked with Steve back in the 90's @ Boeing, great guy, IMHO a great assembler coder I was about to ask about Bob Richards, Last I heard he took a spill and out out of commission for a while Carmen On 12/14/2022 3:21 PM, Sam Golob wrote: Dear Folks, Does anyone know how to get in contact with Steve Myers? Please contact me off list if you can get in touch with him or you know how to contact him. Thanks much. All the best of everything to all of you. Sincerely, Sam Golob. www.cbttape.org -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Carmen -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: DB2 V12 DB2 connect v9.5 problem
Perhaps I am missing something, but the V12R1M500 is the BIND APPLCOMPAT on the mainframe. The client doesn't need any V12 services (or V9, for that matter). How can I bind the PACKAGE so that the client side APPLCOMPAT (of *) is acceptable? Or how can I tell IBM DB2 Client 9.5 to set APPLCOMPAT? Don't see any obvious option or command to set it. On Thu, 15 Dec 2022 08:50:53 +1100 Attila Fogarasi wrote: :>Normally this is due to a back-level client driver which doesn't support :>M502. Installing a new driver on the client system is the usual remedy if :>M502 is really needed (function used in the applications). Otherwise you :>can rebind the package specifying V12R1M500 which should work with the :>existing back-level driver. :> :>On Wed, Dec 14, 2022 at 9:42 PM Binyamin Dissen :>wrote: :> :>> I am getting :>> :>> DSNL076I -DBCG DSNLXSVC DDF CONNECTION REJECTED DUE 794 :>> TO INCOMPATIBLE APPLCOMPAT VALUES. :>>LUWID=P3EBC7B8.H043.DC8D7A13DC85 :>>CLIENTAPPLCOMPAT=* :>>PACKAGEAPPLCOMPAT=V12R1M502 :>>PACKAGE=NULLID.SQLC2G13.41414141414E4758 :>> :>> I cannot figure out how to set the client level APPLCOMPAT or bind the :>> nullid :>> package to match. -- Binyamin Dissen http://www.dissensoftware.com Director, Dissen Software, Bar & Grill - Israel -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
