Re: BMC MainView for DB2
Dear Rex, thank you for your answer. As I have not access to BMC remedy, could you please verify to me if MainView for DB2 v10 is compatible with DB2 v9.1? Thanks in advance Kostas On 23 May 2014 16:01, Pommier, Rex rpomm...@sfgmembers.com wrote: They definitely don't make it easy to find! What I found was 11.1.0 available on 6/25/2013, supported on z/OS 1.12, 1.13, 2.1. DB2 9.1, 10, and 11 are listed as supported. Rex -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of K Sent: Friday, May 23, 2014 7:44 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: BMC MainView for DB2 Hi all, What is the latest generally available version of BMC MainView for DB2? Thanks in advance? -- 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SSD tiering benefits
Thanks for your answer Lizette We are using various tools like IBM RMF ASG TMONZOS in z/OS running SMS HSM. We actually want to tier some very utilized DB2 v9.1 workload to SSD and keep all the rest running in spinning VMAX 15000 rpm disks. I am very interesting in forecasting any potential CPU benefit beside of course the better IO. How can we project this? On 7 August 2013 12:55, Lizette Koehler stars...@mindspring.com wrote: What tools do you have? Do you have SAS SAS/MXG SAS/MICS, Omegamon (Tivoli), DISK Magic, etc... What version of z/OS, DB2? What hardware is used? EMC (VMAX, other), HDS, IBM? RMF which creates the Type 70 records, should contain some of the information you are looking for. Do you have experience in Performance analysis? If you do, what tools do you normally use? What will you be using for tiering? Each hardware vendors have their own tiering solutions. I think DISK magic (fee product) by Intellimagic can do what if analysis. My understanding is that Tiering is used to move less active data to slower devices inside a storage array and put highly accessed data on faster devices in the array. That tiering is used to smooth out the hot spots in the array itself. Or move data from more expensive storage (SSD) to less expensive (SATA) devices within the array. So is your issue hot spots in the array and DB2 requires better performance (1 ms or less per transaction)? Are you mixing SSD to SATA type devices and want to ensure high access data is on the fast device? What is the problem you are trying to solve with SSD drives? Do you use DFHSM and DFSMS to manage your storage? Do you have a mixed DFSMS pool with both Spinning and SSD disks? Is the SMS pool a pure DB2 table pool or share with non-VSAM? Are your DB2 Tables currently on SSD or spinning disks? Or on mixed devices? Do you use your Storage groups to direct your DB2 tables to SSD? Lizette -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of K Sent: Wednesday, August 07, 2013 1:28 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: SSD tiering benefits Dear Listers, We are thinking to implement storage tiering using some SSD volumes for some of our very active DB2 tablespaces. Is there any way to measure performance improvements for both CPU and IO utilization? Do you have any experience on tiering with SSD in DB2 environment? Kind regards Kostas -- 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: Retrieving jobs of input queue
Hi all, Thank you for your answers. Note that I would like to bypass in my REXX the use of address ISFEXEC or ISFACT. This is because I am not using standard TSO REXX but OPS/MVS REXX which is not supporting (yet) a host environment to SDSF. Kind regards On 18 June 2013 23:35, Kirk Wolf k...@dovetail.com wrote: You can use the lsjes command: See: https://www.dovetail.com/docs/coz/dsp-ref_lsjes.html This could be called from REXX using bpxwunix() or the SH host command environment. Also, the fromdsn command can be used to extract spool files for a job. Kirk Wolf Dovetailed Technologies http://dovetail.com PS The Co:Z Toolkit is free to download and use under our Community License. Enterprise License and Support agreements are also available: http://dovetail.com/support.html On Tue, Jun 18, 2013 at 9:17 AM, K kzafi...@gmail.com wrote: Hello all Could I retrieve Jobs and their jobids of JES2 input queue though REXX but WITHOUT use of SDSF. Kind regards Kostas -- 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Retrieving jobs of input queue
Hi all I rather try to use JES2 command $djq,q=xeq,busy=no to find out jobs awaiting in INPUT queue Thanks in any case On 19 June 2013 10:20, k Zaf kzafi...@gmail.com wrote: Hi all, Thank you for your answers. Note that I would like to bypass in my REXX the use of address ISFEXEC or ISFACT. This is because I am not using standard TSO REXX but OPS/MVS REXX which is not supporting (yet) a host environment to SDSF. Kind regards On 18 June 2013 23:35, Kirk Wolf k...@dovetail.com wrote: You can use the lsjes command: See: https://www.dovetail.com/docs/coz/dsp-ref_lsjes.html This could be called from REXX using bpxwunix() or the SH host command environment. Also, the fromdsn command can be used to extract spool files for a job. Kirk Wolf Dovetailed Technologies http://dovetail.com PS The Co:Z Toolkit is free to download and use under our Community License. Enterprise License and Support agreements are also available: http://dovetail.com/support.html On Tue, Jun 18, 2013 at 9:17 AM, K kzafi...@gmail.com wrote: Hello all Could I retrieve Jobs and their jobids of JES2 input queue though REXX but WITHOUT use of SDSF. Kind regards Kostas -- 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: ICETOOL question
Dear All I could never thought that DFSORT should help to produce percentages of the records... Thank you for your (more or less tricky) help Kind regards Kostas On 10 May 2013 20:10, Norbert Friemel nf.ibmm...@web.de wrote: On Fri, 10 May 2013 08:53:40 -0500, K wrote: Two steps: //* //S1 EXEC PGM=ICETOOL //* //TOOLMSG DD SYSOUT=* //DFSMSGDD SYSOUT=* //DATA DD DISP=(,PASS), // DSN=amp;DATA, // SPACE=(80,(10,10)),AVGREC=U, // LRECL=80,RECFM=FB //TOTAL DD DISP=(,PASS), // DSN=amp;TOTAL, // SPACE=(80,(1,1)),AVGREC=U, // LRECL=80,RECFM=FB //INDD * AAA BBB AAA CCC AAA BBB /* //TOOLINDD * COPY FROM(IN) TO(DATA) COUNT FROM(DATA) WRITE(TOTAL) TEXT('Total#,+') DIGITS(9) WIDTH(80) /* //* //S2 EXEC PGM=SORT //* //SYSOUTDD SYSOUT=* //SYMNOUT DD SYSOUT=* //SORTINDD DISP=(OLD,DELETE), // DSN=amp;DATA //SORTOUT DD SYSOUT=* //SYMNAMES DD DISP=(OLD,DELETE), // DSN=amp;TOTAL //SYSIN DD * SORT FIELDS=(1,3,CH,A) INREC BUILD=(1,3,+1,TO=PD,LENGTH=5,Total#,TO=PD,LENGTH=5) SUM FIELDS=(4,5,PD) OUTREC BUILD=(1,3,(((4,5,PD,DIV,9,5,PD),ADD,+5),DIV,+10), EDIT=(IIIT,T%)) /* Norbert Friemel Hi dear all, I would like to produce a statistic report using ICETOOL. This report should shown the percentage of records in the file according to their values e.g. Input: AAA BBB AAA CCC AAA BBB Output Percentages: AAA 50,0 BBB 33,0 CCC 16,7 Is there any ICETOOL operator (like OCCUR) to find out the above percentage? Do I have to use various INCLUDE COND and then read the DFSMSG to extract percentages (from ICE054I 0 RECORDS - IN: xxx, OUT: yyy) ? Thanks in advance Kzafirop at gmail dot com -- 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 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN