FTPS using zVM FTP client ?
We have a vendor that we need to ftp files to from our zVM 5.4 system. The vendor says we need to use FTPS over IMPLICIT TLS/SSL. I have been reading the TCPIP Users Guide and it appears the this is possible from our zVM 5.4 system if I configure and use the SECURECONTROL and SECUREDATA statements in a FTP DATA file, which I have done. So far I have not had any luck connecting to them. If anyone else has done something similar can you tell me if I am missing something? Thank you in advance... Bill Pettit
Re: MAILIT question
Unfortunately I am not any more than an entry level PIPE's person. I am guessing though that inside pipes it must be using CSL routines for it's SFS access to get to my PDF files to attach, and I would really like to see the return codes from those CSL routines (if that's how it's done). Anyone know if that's possible? Bill -Original Message- From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Kris Buelens Sent: Friday, January 21, 2011 1:27 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: MAILIT question I tested MAILIT today with an ATTACH of a not existing file, and in such a case nothing gets sent. I just looked at the code. the actual sending to SMTP happens in SendNetDataFile: 'PIPE (Name PunchMail end ~) STEM HEAD.', /* take the header info */ SmtpPrefFil, /* Maybe attach SMTP files */ SmtpBodyHdr, /* Maybe insert header for body */ '|APPEND VAR PrefaceText||Deblock Linend', /* The preface */ '|APPEND VAR Contents||Deblock Linend', /* The body of the file */ '|APPEND VAR AppendText||Deblock Linend', /* The preface*/ left('|CONSOLE',8*console), SmtpAttFil, /* Maybe attach SMTP files */ FixDotLineForSmtp,/* Maybe fix a line with . only */ ApndMailTrail, /* take the trailer info */ padding, /* pad with blanks if FIXED file */ '|CHANGE //'||'00'x||'/', /* Tell it are data records */ '|PREFACE VAR INMR03',/* add INMR header record */ '|PREFACE VAR INMR02',/* add INMR header record */ '|PREFACE VAR INMR04',/* add INMR user parms */ '|PREFACE VAR INMR01',/* add INMR header record */ '|APPEND VAR INMR06', /* add INMR trailer record */ '|CT1: COUNT bytes', '|BLOCK 80 NETDATA', /* Make NETDATA punch format */ '|CT2: COUNT bytes', '|PUNCH', '~CT1:|VAR CT1 ~CT2:|VAR CT2' if rc0 then do call diag 8,'SPOOL D PURGE' /* remove unfinished spool file */ return 405 'PIPE had problems with PUNCH' end The SMTPATTFIL Rexx variable -used above- contains a stage to read the files to attach, and that should set this PIPE's rc to non-zero when it fails, and the punched file would get purged. What MAILIT also does is purging any unclosed spool file data on 000D before it starts to punch itself with the above PIPE. 2011/1/21 Hughes, Jim jim.hug...@doit.nh.govmailto:jim.hug...@doit.nh.gov Have you looked at these spool files containing 4 records? If so, what do they look like? James R. Hughes TSG, Problem Solver NH Department of Information Technology 603-271-5586(w); 603-491-3071(c) www.nh.gov/doithttp://www.nh.gov/doit Statement of Confidentiality: The contents of this message are confidential. Any unauthorized disclosure, reproduction, use or dissemination (either whole or in part) is prohibited. If you are not the intended recipient of this message, please notify the sender immediately and delete the message from your system. It is fun to do the impossible. _ From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDUmailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Bill Pettit Sent: Friday, January 21, 2011 12:42 PM To: IBMVM@LISTSERV.UARK.EDUmailto:IBMVM@LISTSERV.UARK.EDU Subject: Re: MAILIT question Kris; I have verified the PDF files that MAILIT is attempting to send as attached files are not empty PDF files. And for several weeks I have been displaying the return code from the MAILIT call in my EXEC. Below are snippets of the console files from my exec calling MAILIT and my SMTP server. This only happens once in a while and never for all of the files/emails being sent during a particular call to the process. On this night (1/18) there were 176 emails sent with attached PDF files, and 7 were rejected by SMTP as being null. I read in one of the files that got rejected to my reader by SMTP, I can tell it's a file from MAILIT but that is about it. IF my SFS server rejected the request from MAILIT to access the PDF file I am trying to attach to my the email, would MAILIT report that rejection in it's return code when it comes back to my exec? === From my exec calling MAILIT === 13612 Send_attached_file: 13613dfer...@serinc.netmailto:dfer...@serinc.net23 PDF R1 22:20:53 13614 Mailit-rc= 0 13615 * From SMTP: Received Spool File 3875 === From my SMTP machine === 04451 RDR FILE 3874 SENT FROM ARPTSRVR PUN WAS 6954 RECS 0191 CPY 001 A NOHOLD NOKEEP - 04452 RDR FILE 3875 SENT FROM ARPTSRVR PUN WAS 6955 RECS 0004 CPY 001 A NOHOLD NOKEEP - 04453 DTCSMT1227E 01/18/11 22:20:53 Null Spool File: 3875 transferred to BILLP 04454 RDR FILE 3876 SENT FROM ARPTSRVR PUN WAS 6956 RECS 0200 CPY 001 A NOHOLD NOKEEP 04455 RDR FILE 3877 SENT FROM
Re: MAILIT question
Thank you!! I will get a copy of the file on the way this morning. Bill -Original Message- From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Kris Buelens Sent: Tuesday, January 25, 2011 7:15 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: MAILIT question PIPE doesn't always use CSL call to read SFS files. It depends on what is specified in the parameters coded on the stage. MAILIT passes a filemode, so PIPE will use the classic driver mdsk and not SFS. And, indeed, I have some vague memories having encountered some problem where PIPE gave RC=0 with a problem in SFS. When using SFS, PIPE did indeed display the correct CSL reasoncodes and ended with a non-zero returncode. With the following change, you can instruct MAILIT to use to use SFS if possible: Go to subroutine: SMTP_MimeFiles: /* Handle MIME headers for SMTP attached files.*/ Some 25 lines down, make it read as follows, the red lines are new. if MimeOpt.at#.0TXT then do mRead='VAR MIMEOPT.'at#'.0STR direct!Deblock Linend 'PIPE' mRead'!COUNT bytes MaxLine!VAR T' parse var t siz lrecl end; else do t=left(strip(fm),1) call csl 'DMSQFMOD retc reas t buffer flag' Select When reas0 then mRead='' fn ft fm when flag=3!flag=4 then mRead='' fn ft fm Otherwise mRead='SFS' fn ft fm 'WORKUNIT PRIVATE' end /*say 'mRead='mread */ parse var MimeOpt.at#.0SIZE siz lrecl end If that indeed cures the problem, I could make that change to MAILIT for everyone. (cure is not the right word here, better is make the SFS problem visible). You could also send me such a small, 4 records, file s that I can have a look at it: - transfer such a file to your reader - PIPE READER FILE | RDRFILE A - VMARC PACK RDRFILE A MAILPRB VMARC A and send me the VMARC 2011/1/25 Bill Pettit bill.pet...@ormutual.commailto:bill.pet...@ormutual.com Unfortunately I am not any more than an entry level PIPE's person. I am guessing though that inside pipes it must be using CSL routines for it's SFS access to get to my PDF files to attach, and I would really like to see the return codes from those CSL routines (if that's how it's done). Anyone know if that's possible? Bill -Original Message- From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDUmailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Kris Buelens Sent: Friday, January 21, 2011 1:27 PM To: IBMVM@LISTSERV.UARK.EDUmailto:IBMVM@LISTSERV.UARK.EDU Subject: Re: MAILIT question I tested MAILIT today with an ATTACH of a not existing file, and in such a case nothing gets sent. I just looked at the code. the actual sending to SMTP happens in SendNetDataFile: 'PIPE (Name PunchMail end ~) STEM HEAD.', /* take the header info */ SmtpPrefFil, /* Maybe attach SMTP files */ SmtpBodyHdr, /* Maybe insert header for body */ '|APPEND VAR PrefaceText||Deblock Linend', /* The preface */ '|APPEND VAR Contents||Deblock Linend', /* The body of the file */ '|APPEND VAR AppendText||Deblock Linend', /* The preface*/ left('|CONSOLE',8*console), SmtpAttFil, /* Maybe attach SMTP files */ FixDotLineForSmtp,/* Maybe fix a line with . only */ ApndMailTrail, /* take the trailer info */ padding, /* pad with blanks if FIXED file */ '|CHANGE //'||'00'x||'/', /* Tell it are data records */ '|PREFACE VAR INMR03',/* add INMR header record */ '|PREFACE VAR INMR02',/* add INMR header record */ '|PREFACE VAR INMR04',/* add INMR user parms */ '|PREFACE VAR INMR01',/* add INMR header record */ '|APPEND VAR INMR06', /* add INMR trailer record */ '|CT1: COUNT bytes', '|BLOCK 80 NETDATA', /* Make NETDATA punch format */ '|CT2: COUNT bytes', '|PUNCH', '~CT1:|VAR CT1 ~CT2:|VAR CT2' if rc0 then do call diag 8,'SPOOL D PURGE' /* remove unfinished spool file */ return 405 'PIPE had problems with PUNCH' end The SMTPATTFIL Rexx variable -used above- contains a stage to read the files to attach, and that should set this PIPE's rc to non-zero when it fails, and the punched file would get purged. What MAILIT also does is purging any unclosed spool file data on 000D before it starts to punch itself with the above PIPE. 2011/1/21 Hughes, Jim jim.hug...@doit.nh.govmailto:jim.hug...@doit.nh.gov Have you looked at these spool files containing 4 records? If so, what do they look like? James R. Hughes TSG, Problem Solver NH Department of Information Technology 603-271-5586(w); 603-491-3071(c) www.nh.gov/doithttp://www.nh.gov/doit Statement of Confidentiality: The contents of this message are confidential. Any unauthorized disclosure, reproduction, use or dissemination (either whole or in part) is prohibited. If you
Re: MAILIT question
Kris; I have verified the PDF files that MAILIT is attempting to send as attached files are not empty PDF files. And for several weeks I have been displaying the return code from the MAILIT call in my EXEC. Below are snippets of the console files from my exec calling MAILIT and my SMTP server. This only happens once in a while and never for all of the files/emails being sent during a particular call to the process. On this night (1/18) there were 176 emails sent with attached PDF files, and 7 were rejected by SMTP as being null. I read in one of the files that got rejected to my reader by SMTP, I can tell it's a file from MAILIT but that is about it. IF my SFS server rejected the request from MAILIT to access the PDF file I am trying to attach to my the email, would MAILIT report that rejection in it's return code when it comes back to my exec? === From my exec calling MAILIT === 13612 Send_attached_file: 13613dfer...@serinc.netmailto:dfer...@serinc.net23 PDF R1 22:20:53 13614 Mailit-rc= 0 13615 * From SMTP: Received Spool File 3875 === From my SMTP machine === 04451 RDR FILE 3874 SENT FROM ARPTSRVR PUN WAS 6954 RECS 0191 CPY 001 A NOHOLD NOKEEP - 04452 RDR FILE 3875 SENT FROM ARPTSRVR PUN WAS 6955 RECS 0004 CPY 001 A NOHOLD NOKEEP - 04453 DTCSMT1227E 01/18/11 22:20:53 Null Spool File: 3875 transferred to BILLP 04454 RDR FILE 3876 SENT FROM ARPTSRVR PUN WAS 6956 RECS 0200 CPY 001 A NOHOLD NOKEEP 04455 RDR FILE 3877 SENT FROM ARPTSRVR PUN WAS 6957 RECS 0004 CPY 001 A NOHOLD NOKEEP 04456 DTCSMT1227E 01/18/11 22:21:13 Null Spool File: 3877 transferred to BILLP 04457 RDR FILE 3878 SENT FROM ARPTSRVR PUN WAS 6958 RECS 0192 CPY 001 A NOHOLD NOKEEP 04458 RDR FILE 3879 SENT FROM ARPTSRVR PUN WAS 6959 RECS 0192 CPY 001 A NOHOLD NOKEEP 04459 RDR FILE 3880 SENT FROM ARPTSRVR PUN WAS 6960 RECS 0004 CPY 001 A NOHOLD NOKEEP 04460 DTCSMT1227E 01/18/11 22:21:43 Null Spool File: 3880 transferred to BILLP === Thank you Bill -Original Message- From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDU] On Behalf Of Kris Buelens Sent: Thursday, January 20, 2011 9:41 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: MAILIT question No, no-oneever told me about such problems. Note that there are no timeout mechanisms in SFS, so a slow SFS server can only cause a slowdown of MAILIT. At the other hand, if the SMTP server on VM is slowed down, maybe the mail server it is sending mail too gets impatient? MAILIT can not know if SMTP dislikes a mail file: it doesn't communicate with SMTP: it simply creates a spool file and send that to SMTP. If you suspect MAILIT gives RC 0 when a file to attach isn't found, simply try it out? Like this MAILIT TEST TO( at ) subject test attach(notexist file) text this is a test 2011/1/20 Bill Pettit bill.pet...@ormutual.commailto:bill.pet...@ormutual.com I have been using MAILIT to send emails with attached PDF files for several months now. 99.5% of the time it works like a champ, no errors. But, every now and then I find a few of the emails rejected by SMTP, he says it he rejecting them because they are NULL files. I have nailed this down I think to periods when my SFS server is very busy receiving files from other processes that are running at the same time, it just depends where we are in our nightly batch cycle if this happens to coincide with the sending of the emails with the attached PDF files. The problem is MAILIT always returns me a zero return code, whether the files are rejected by SMTP or not. I am suspecting (and hoping) that MAILIT is getting a return code from SFS saying it cannot provide the file for MAILIT to attach when MAILIT is building the email, but I have not been able to verify that yet. Anyone else that is using MAILIT have a similar experience? Thank you Bill Pettit -- Kris Buelens, IBM Belgium, VM customer support
MAILIT question
I have been using MAILIT to send emails with attached PDF files for several months now. 99.5% of the time it works like a champ, no errors. But, every now and then I find a few of the emails rejected by SMTP, he says it he rejecting them because they are NULL files. I have nailed this down I think to periods when my SFS server is very busy receiving files from other processes that are running at the same time, it just depends where we are in our nightly batch cycle if this happens to coincide with the sending of the emails with the attached PDF files. The problem is MAILIT always returns me a zero return code, whether the files are rejected by SMTP or not. I am suspecting (and hoping) that MAILIT is getting a return code from SFS saying it cannot provide the file for MAILIT to attach when MAILIT is building the email, but I have not been able to verify that yet. Anyone else that is using MAILIT have a similar experience? Thank you Bill Pettit
Modifying the SFS Log Backup Threshold ?
Does anyone know if there is a way to modify to reduce the SFS Log Backup Threshold from 80%? I have been searching the CMS File Pool manual and cannot find any reference to being able to alter it. TIA Bill
Re: Modifying the SFS Log Backup Threshold ?
Thank you Richard! We came to the same conclusion. Bill -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Schuh, Richard Sent: Friday, October 22, 2010 2:03 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Modifying the SFS Log Backup Threshold ? I asked the same question a few months ago. There is no way other than having a service machine monitor the file pool and issue the backup command at a lower %. Regards, Richard Schuh -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Bill Pettit Sent: Friday, October 22, 2010 1:28 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Modifying the SFS Log Backup Threshold ? Does anyone know if there is a way to modify to reduce the SFS Log Backup Threshold from 80%? I have been searching the CMS File Pool manual and cannot find any reference to being able to alter it. TIA Bill
Re: Sending files from CMS as Attachments
Does anyone out there have a copy of the SMTPNOTE EXEC that has been modified to send attached PDF files without destroying the format of the PDF files? My old copy from 1999 is hammering the PDF attachment. Thank you Bill Pettit -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of peter.w...@ttc.ca Sent: Wednesday, June 20, 2007 11:14 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Sending files from CMS as Attachments I use SMTPNOTE EXEC to do this. -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Davis, Larry Sent: June 20, 2007 09:10 To: IBMVM@LISTSERV.UARK.EDU Subject: Sending files from CMS as Attachments Is there any method to send a CMS file as an attachment in an email? We have applications which produce formatted documents like PDF's and the user wants to send them to their clients, but sendfile incorporates the files into the email, rather than attaching the file. Any Help would be greatly appreciated. Larry Davis _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review retransmission dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient or delegate is strictly prohibited. If you received this in error please contact the sender and delete the material from any computer. The integrity and security of this message cannot by guaranteed on the Internet. The Sender accepts no liability for the content of this e-mail or for the consequences of any actions taken on basis of the information provided. The recipient should check this e-mail and any attachments for the presence of viruses. The sender accepts no liability for any damage caused by any virus transmitted by this e-mail. This disclaimer is the property of the TTC and must not be altered or circumvented in any manner.
Re: Sending files from CMS as Attachments
I'll give it a try. Thank you. Bill -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Lionel Dyck Sent: Thursday, August 26, 2010 1:57 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Sending files from CMS as Attachments What about the MAILIT from the IBM z/VM Download page http://www.vm.ibm.com/download/packages/mailit.vmarc It can handle binary attachments. Lionel _ Lionel B. Dyck z/Linux Specialist IBM Corporation Global Technology Services - Kaiser Account Work: 925-926-5332 Cell: 925-348-0237 E-Mail: ld...@us.ibm.com AIM: lbdyck | Yahoo IM: lbdyck | GTalk: lbdyck http://www.ibm.com/ibm/values/ From:Bill Pettit bill.pet...@ormutual.com To:IBMVM@LISTSERV.UARK.EDU Date:08/26/2010 01:53 PM Subject:Re: Sending files from CMS as Attachments Sent by:The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU _ Does anyone out there have a copy of the SMTPNOTE EXEC that has been modified to send attached PDF files without destroying the format of the PDF files? My old copy from 1999 is hammering the PDF attachment. Thank you Bill Pettit -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of peter.w...@ttc.ca Sent: Wednesday, June 20, 2007 11:14 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Sending files from CMS as Attachments I use SMTPNOTE EXEC to do this. -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Davis, Larry Sent: June 20, 2007 09:10 To: IBMVM@LISTSERV.UARK.EDU Subject: Sending files from CMS as Attachments Is there any method to send a CMS file as an attachment in an email? We have applications which produce formatted documents like PDF's and the user wants to send them to their clients, but sendfile incorporates the files into the email, rather than attaching the file. Any Help would be greatly appreciated. Larry Davis _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review retransmission dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient or delegate is strictly prohibited. If you received this in error please contact the sender and delete the material from any computer. The integrity and security of this message cannot by guaranteed on the Internet. The Sender accepts no liability for the content of this e-mail or for the consequences of any actions taken on basis of the information provided. The recipient should check this e-mail and any attachments for the presence of viruses. The sender accepts no liability for any damage caused by any virus transmitted by this e-mail. This disclaimer is the property of the TTC and must not be altered or circumvented in any manner.
Re: Sending files from CMS as Attachments
Yep, I had finally broke down and pulled up the CMS manual and found the mime binary-attach option that I was missing. It helps to practice what you preach... Thank you all Bill -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Alan Altmark Sent: Thursday, August 26, 2010 3:00 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Sending files from CMS as Attachments On Thursday, 08/26/2010 at 05:00 EDT, Lionel Dyck/Oakland/i...@ibmus wrote: What about the MAILIT from the IBM z/VM Download page http://www.vm.ibm.com/download/packages/mailit.vmarc It can handle binary attachments. Anything wrong with SENDFILE? SF MY PDF TO user AT domain.com (MIME BINARY-ATTACH SUBJECT 'Here is the PDF you wanted' Alan Altmark z/VM Development IBM Endicott
Re: VM DB2 7.3 question
Thank you Roland. This was the information I have been looking for. Bill Pettit -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Roland P. Chung Sent: Thursday, January 28, 2010 8:38 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: VM DB2 7.3 question Hi Bill, This means the agent wants to read a directory block from disk, but there are no available directory buffers, so the agent waits for another agent to free up a buffer. When a buffer is freed, this agent will be un-waited so it can try to get the buffer again. This indicates an increase in the number of Directory buffers is needed. There is also an out of page wait state for when page buffers are all in use. I hope this helps. ...Roland --- On Thu, 1/28/10, Bill Pettit bill.pet...@ormutual.com wrote: --- snipped --- -Original Message- From: The IBM z/VM Operating System [mailto:IBMVM@LISTSERV.UARK.EDUhttp://ca.mc881.mail.yahoo.com/mc/compose?to=ib...@listserv.uark.edu] On Behalf Of Bill Pettit Sent: Wednesday, January 27, 2010 5:20 PM To: IBMVM@LISTSERV.UARK.EDUhttp://ca..mc881.mail.yahoo.com/mc/compose?to=ib...@listserv.uark.edu Subject: VM DB2 7.3 question We encountered several slow running batch jobs last night and the only thing that stood out was the following entry when the operator command SHOW ACTIVE was entered: User Agent: 4 User ID: ONLINE is R/O APPL 2431F6FE Agent is processing and is in out of block wait. I have been searching off and on through the manuals today and I still cannot find any reference to the Agent is processing and is in out of block wait condition, and what it is attributed to. I suspect it has something to do with a shortage of the lock request blocks allowed and available for an active user, but I cannot find anything that actually tells me that.. Anyone have any knowledge about what this message means? Thank you Bill Pettit
Re: VM DB2 7.3 question
Unfortunately no monitor. Not since CA pulled the rug out from under the DBMonitor product Sterling had. Thank you Nora. Bill -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Graves Nora E Sent: Thursday, January 28, 2010 6:46 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: VM DB2 7.3 question Do you run a User Locking monitor? If so, you can view the report at any time from the Control Center Monitor List function. That will show you the number of User and System blocks allocated and used. I do not see any references to this condition either. Nora Graves nora.e.gra...@irs.gov Main IRS, Room 6531 (202) 622-6735 Fax (202) 622-3123 -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Bill Pettit Sent: Wednesday, January 27, 2010 5:20 PM To: IBMVM@LISTSERV.UARK.EDU Subject: VM DB2 7.3 question We encountered several slow running batch jobs last night and the only thing that stood out was the following entry when the operator command SHOW ACTIVE was entered: User Agent: 4 User ID: ONLINE is R/O APPL 2431F6FE Agent is processing and is in out of block wait. I have been searching off and on through the manuals today and I still cannot find any reference to the Agent is processing and is in out of block wait condition, and what it is attributed to. I suspect it has something to do with a shortage of the lock request blocks allowed and available for an active user, but I cannot find anything that actually tells me that. Anyone have any knowledge about what this message means? Thank you Bill Pettit
VM DB2 7.3 question
We encountered several slow running batch jobs last night and the only thing that stood out was the following entry when the operator command SHOW ACTIVE was entered: User Agent: 4 User ID: ONLINE is R/O APPL 2431F6FE Agent is processing and is in out of block wait. I have been searching off and on through the manuals today and I still cannot find any reference to the Agent is processing and is in out of block wait condition, and what it is attributed to. I suspect it has something to do with a shortage of the lock request blocks allowed and available for an active user, but I cannot find anything that actually tells me that. Anyone have any knowledge about what this message means? Thank you Bill Pettit
Re: Unofficial DB2 Servr for VSE VM survey
Please send me a copy. Bill Pettit Systems Programming Manager Oregon Mutual Insurance Co -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Roland P. Chung Sent: Tuesday, October 13, 2009 11:44 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Unofficial DB2 Servr for VSE VM survey ** CROSS POSTED to VSE-L ** Hello Listers, if you are interested, please let me know, I will send the survey to you off the List. There may be some surprises if you complete the survey and return the survey to db2vs...@ca.ibm.comhttp://ca.mc881.mail.yahoo.com/mc/compose?to=db2vs...@ca.ibm.com. Thanks. ...Roland P.S. Found out in a hard way that the List rejects the posting with MS/WORD attachement. Umm
Re: DB2 Problem
Do you have the REXX SQL option available to you? Bill -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Tom Duerbusch Sent: Tuesday, June 16, 2009 10:38 AM To: IBMVM@LISTSERV.UARK.EDU Subject: DB2 Problem I don't believe that this is a DB2 Server code problem, just how I'm coding it, is a problem G. I have a table, that a process adds records to it. On an hourly basis, I kick off a job that copies all the records in that table, inserts them into another table, and then deletes all records in the first table, all within the same LUW. However, if the process that adds records to the table, is adding records during this merge/purge process, some records are deleted without being merged. I didn't think that was suppose to happen. After stripping out all the other code, and coding the remaining code in a DB2 Batch Utility step, I see that I do have a problem. I don't know if I'm confusing DB2, as the table I insert from, is a View. The table I delete from, is the real table. ARI0801I DBS Utility started: 06/16/09 10:29:35. AUTOCOMMIT = OFF ERRORMODE = OFF ISOLATION LEVEL = REPEATABLE READ -- CONNECT SYSA IDENTIFIED BY ; ARI8004I User SYSA connected to server STLDB01. ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 0 -- -- COMMENT 'PAYROLL SYSTEM' -- -- LOCK DBSPACE PERSHIST IN EXCLUSIVE MODE;=== lock the dbspace of ershist_xx ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 0 -- INSERT INTO STL01.ERS_HISTORY_A --SELECT * FROM ASN.ERSHIST_X; ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 3 === I've inserted 3 records -- -- DELETE FROM ASN.CDERS_HISTORY -- ; ARI0501I An SQL warning has occurred. Database manager processing is completed. Warning may indicate a problem. ARI0505I SQLCODE = 0 SQLSTATE = 01504 ROWCOUNT = 30705 === I'ved deleted 30705 records ARI0502I Following SQL warning conditions encountered: NULLWHERE -- COMMIT WORK; ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 0 -- SET ERRORMODE OFF; ARI0899I ...Command ignored. -- ARI0802I End of command file input. ARI8997I ...Begin COMMIT processing. ARI0811I ...COMMIT of any database changes successful. ARI0809I ...No errors occurred during command processing. ARI0808I DBS processing completed: 06/16/09 10:30:31. I don't really have a good option for stopping the process that adds records. 99.99% of the time, no records are added during the merge/purge process. However, if a batch job add/chg/deleted a lot of records in a signal LUW, as in 100,000 or more, it is possible that the merge/purge runs while records were still being added, which then I might loose some records. I thought locking the DBSPACE that I'm doing the merge/purge from, would do the trick. I thought that the process that was adding records, would be held on a LOCK, and wait (perhaps till -911, in which case it will delay and restart), but the lock didn't seem to do the trick. Between Repeatable Read and Locking the DBSPACE didn't do what I needed. Is there another option, without taking down the database to Single User Mode, or terminating the process that is adding records, not to loose records in the merge/purge process? Thanks Tom Duerbusch THD Consulting
Re: DB2 Problem
Can you add another select statement with the same where clause as your select-insert roll, and write a temporary control file with each record containing enough information to identify the selected row, then after the select-insert roll read back the file and use it to do the deletes using rxsql? Bill -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Tom Duerbusch Sent: Tuesday, June 16, 2009 12:55 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: DB2 Problem Perhaps. This is on VSE which doesn't have REXX SQL from IBM. However, we do have REXXSQL from SPR which does the same thing. BTW, the original program was written in REXXSQL. I tore everything out and put it in the DB2 Batch Utility to eliminate the possibility of a commit being accidently put in by the product developers. Tom Duerbusch THD Consulting Bill Pettit bi...@ormutual.com 6/16/2009 1:59 PM Do you have the REXX SQL option available to you? Bill -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Tom Duerbusch Sent: Tuesday, June 16, 2009 10:38 AM To: IBMVM@LISTSERV.UARK.EDU Subject: DB2 Problem I don't believe that this is a DB2 Server code problem, just how I'm coding it, is a problem G. I have a table, that a process adds records to it. On an hourly basis, I kick off a job that copies all the records in that table, inserts them into another table, and then deletes all records in the first table, all within the same LUW. However, if the process that adds records to the table, is adding records during this merge/purge process, some records are deleted without being merged. I didn't think that was suppose to happen. After stripping out all the other code, and coding the remaining code in a DB2 Batch Utility step, I see that I do have a problem. I don't know if I'm confusing DB2, as the table I insert from, is a View. The table I delete from, is the real table. ARI0801I DBS Utility started: 06/16/09 10:29:35. AUTOCOMMIT = OFF ERRORMODE = OFF ISOLATION LEVEL = REPEATABLE READ -- CONNECT SYSA IDENTIFIED BY ; ARI8004I User SYSA connected to server STLDB01. ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 0 -- -- COMMENT 'PAYROLL SYSTEM' -- -- LOCK DBSPACE PERSHIST IN EXCLUSIVE MODE;=== lock the dbspace of ershist_xx ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 0 -- INSERT INTO STL01.ERS_HISTORY_A --SELECT * FROM ASN.ERSHIST_X; ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 3 === I've inserted 3 records -- -- DELETE FROM ASN.CDERS_HISTORY -- ; ARI0501I An SQL warning has occurred. Database manager processing is completed. Warning may indicate a problem. ARI0505I SQLCODE = 0 SQLSTATE = 01504 ROWCOUNT = 30705 === I'ved deleted 30705 records ARI0502I Following SQL warning conditions encountered: NULLWHERE -- COMMIT WORK; ARI0500I SQL processing was successful. ARI0505I SQLCODE = 0 SQLSTATE = 0 ROWCOUNT = 0 -- SET ERRORMODE OFF; ARI0899I ...Command ignored. -- ARI0802I End of command file input. ARI8997I ...Begin COMMIT processing. ARI0811I ...COMMIT of any database changes successful. ARI0809I ...No errors occurred during command processing. ARI0808I DBS processing completed: 06/16/09 10:30:31. I don't really have a good option for stopping the process that adds records. 99.99% of the time, no records are added during the merge/purge process. However, if a batch job add/chg/deleted a lot of records in a signal LUW, as in 100,000 or more, it is possible that the merge/purge runs while records were still being added, which then I might loose some records. I thought locking the DBSPACE that I'm doing the merge/purge from, would do the trick. I thought that the process that was adding records, would be held on a LOCK, and wait (perhaps till -911, in which case it will delay and restart), but the lock didn't seem to do the trick. Between Repeatable Read and Locking the DBSPACE didn't do what I needed. Is there another option, without taking down the database to Single User Mode, or terminating the process that is adding records, not to loose records in the merge/purge process? Thanks Tom Duerbusch THD Consulting
Re: whitehouse email
I was there and I don't remember any of our Operators being fired or re-assigned. Who are you referring to that was fired? Bill Pettit -Original Message- From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of Phillip Parmelee Sent: Monday, May 05, 2008 7:54 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: whitehouse email Yes, but the operator who suggested to the FBI that they look at the backups ended up being fired. Phil Parmelee IBM Global Services VM/VSE Team Harrisburg, PA 717-526-1250 T/L 239-1250 [EMAIL PROTECTED] Inactive hide details for August Carideo [EMAIL PROTECTED]August Carideo [EMAIL PROTECTED] August Carideo [EMAIL PROTECTED] Sent by: The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU 05/05/2008 10:40 AM Please respond to The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU To IBMVM@LISTSERV.UARK.EDU cc Subject Re: whitehouse email he was using PROFS so it was MF based and of course it was backed up Edward M. Martin [EMAIL PROTECTED] To com IBMVM@LISTSERV.UARK.EDU Sent by: The IBM cc z/VM Operating System Subject [EMAIL PROTECTED] Re: whitehouse email ARK.EDU 05/05/2008 09:20 AM Please respond to The IBM z/VM Operating System [EMAIL PROTECTED] ARK.EDU Seems that Oliver North got in trouble because there were off-site backups. Seems like that minor problem (having off-site backups) got fixed. Ed Martin 330-588-4723 ext 40441 -Original Message- From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of O'Brien, Dennis L Sent: Friday, May 02, 2008 7:18 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: whitehouse email The backups are kept safe and sound, right next to the Iraqi weapons of mass destruction. But yeah, compared to the Clintons, the Bush regime has been remarkably scandal-free. Dennis It's 10:00 PM. Do you know where your backup tapes are? -Original Message- From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of Schuh, Richard Sent: Friday, May 02, 2008 16:13 To: IBMVM@LISTSERV.UARK.EDU Subject: Re: [IBMVM] whitehouse email No backups are needed. They have done nothing wrong or illegal, and not much of historical importance. :-) Regards, Richard Schuh
Re: MONWRITE files
Ohh... This could get interesting -Original Message- From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of barton Sent: Tuesday, March 11, 2008 11:45 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: MONWRITE files Alan, look at what he's collecting. If you don't think that is miscollecting, you should take the class too. Alan Altmark wrote: On Wednesday, 03/12/2008 at 01:09 EDT, barton [EMAIL PROTECTED] wrote: MONWRITE was not even very well accepted 20 years ago when it became available because of the volume of data and mis-collection of data. Eh? MONWRITE is a tool for collecting raw monitor data. It was not, perhaps, accepted 20 years ago as a good way to MANAGE your raw performance data. That hasn't changed. What is there to mis-collect in a tool that is supposed to write to disk every monitor record the system generates? Alan Altmark z/VM Development IBM Endicott
IS Organization question
We have been working with a consultant that has made several organizational change suggestions regarding Information Systems at our company. One of those suggestions is moving our Computer Operations section be part of and managed by the Systems Programming manager. I am curious about how the other mainframe organizations that are watching this list are organized, and what their approximate overall company size is. Along with any other details or pros and cons you want to throw in. We are a VM VSE shop with five Computer Operators and three Systems Programmers. Thank you