Re: FTP of CMS file as attachment - PJBR
Tom, Bill, Marci, Mike, David, Jim, Ed, THANK YOU VERY MUCH FOR YOUR HELP. Now, to your questions: - Yes, I made a mistake, I meant e-mail but for some reason I wrote FTP instead. I'm Sorry for my lapsus. - PJBR means Produccion - Jose Baron Rodriguez. It's just an eyecatcher I tag my posts with so I can locate any reply I get more easily among hundreds of e-mails. Just a trick ;-) Now, this is what I have tested and my results with your great suggestions: - I have used PROFILE EXEC for a plain text file and a z/VM .PDF manual (no better item :-) for a binary file to play with. - First I tried..: sendfile ZVM43 PDF A to jbaron at calculo-sa.es (mime BINARY -- This works fine. - However I just couldn't get a satisfactory sendfile ascii-attachment solution for PROFILE EXEC. It sent me either the file as the e-mail text itself or as two .dat files a bit unconfortable to work with. I tried...: (1) sendfile profile exec a to jbaron at calculo-sa.es (SMTP autosubj uftsync and...: (2) sendfile profile exec a to jbaron at calculo-sa.es (MIME autosubj uftsync variations but since there is no remote UTF server it switches to SMTP, which makes (1) and (2) identical. - So I ended up installing MAILIT VMARC and it works fine with minimum variations: mailit to(jbaron at calculo-sa.es) subject(this is it) attach(profile exec) mailit to(jbaron at calculo-sa.es) subject(this is it) attach(zvm43 pdf) This solution has been the best one I've found to solve the two cases. Again, THANKS A LOT FOR YOUR HELP ! BRGDS, Jose Raul Baron Dpto. Sistemas CALCULO S.A. Pza. de las Cortes, 2 28014 Madrid Tel. 91 330 86 44 / E-mail: jba...@calculo-sa.es P No imprima este e-mail si no es realmente necesario. Do not print this e-mail unless really necessary.
vswitch for layer 2 network on a second level VM guest
Greetings, Intro We are trying to setup a vswitch for a layer 2 network on a second level VM while sharing the OSA With the level 1 VM. We want to setup the second level VM OSA as a trunk on a layer 2 network for LINUX guests. This is only for testing as we will eventually be setting up multiple OSA's in a trunk on a 1st level VM system on a layer 2 network hosting multiple LINUX guest. This is our goal at any rate. Sorry about the intro to what we are trying to accomplish. Problem. The level 2 VM hangs and the CPU goes to 100% on the level 1 VM and we have to force the 2nd level VM. The command we are trying to use is the following. define vswitch vswf500 rdev f500 controller dtcvsw2 eth vlan 1 portt trunk Thank you Russell Gendreau Time Customer Service, Inc. 813-554-2064
Re: FTP of CMS file as attachment - PJBR
Hello Jose, z/VM 4.3 did not support the attachment parameter. I am not sure when it was introduced. Ed Martin Aultman Health Foundation 330-363-5050 ext 35050 -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of jose raul baron Sent: Wednesday, June 17, 2009 9:59 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: FTP of CMS file as attachment - PJBR Tom, Bill, Marci, Mike, David, Jim, Ed, THANK YOU VERY MUCH FOR YOUR HELP. Now, to your questions: - Yes, I made a mistake, I meant e-mail but for some reason I wrote FTP instead. I'm Sorry for my lapsus. - PJBR means Produccion - Jose Baron Rodriguez. It's just an eyecatcher I tag my posts with so I can locate any reply I get more easily among hundreds of e-mails. Just a trick ;-) Now, this is what I have tested and my results with your great suggestions: - I have used PROFILE EXEC for a plain text file and a z/VM .PDF manual (no better item :-) for a binary file to play with. - First I tried..: sendfile ZVM43 PDF A to jbaron at calculo-sa.es (mime BINARY -- This works fine. - However I just couldn't get a satisfactory sendfile ascii-attachment solution for PROFILE EXEC. It sent me either the file as the e-mail text itself or as two .dat files a bit unconfortable to work with. I tried...: (1) sendfile profile exec a to jbaron at calculo-sa.es (SMTP autosubj uftsync and...: (2) sendfile profile exec a to jbaron at calculo-sa.es (MIME autosubj uftsync variations but since there is no remote UTF server it switches to SMTP, which makes (1) and (2) identical. - So I ended up installing MAILIT VMARC and it works fine with minimum variations: mailit to(jbaron at calculo-sa.es) subject(this is it) attach(profile exec) mailit to(jbaron at calculo-sa.es) subject(this is it) attach(zvm43 pdf) This solution has been the best one I've found to solve the two cases. Again, THANKS A LOT FOR YOUR HELP ! BRGDS, Jose Raul Baron Dpto. Sistemas CALCULO S.A. Pza. de las Cortes, 2 28014 Madrid Tel. 91 330 86 44 / E-mail: jba...@calculo-sa.es P No imprima este e-mail si no es realmente necesario. Do not print this e-mail unless really necessary.
FTPSERVE on z/VM to z/OS
Hi We have sent up the FTPSERVE in TCP/IP on z/VM 5.3. We tested it going from z/VM to a PC first and it worked fine. My real goal to get it going from the z/VM LPAR to one of my z/OS LPARS directly. I was able to get on my z/OS LPAR and connect to the FTPSERVE on the z/VM LPAR and FTP data fine. The problem is that when I try to go from the z/VM LPAR to the z/OS LPAR it will not connect to the IP of the z/OS LPAR. Is there some kind of routing that I am missing to go from z/VM to z/OS directly? Thank You, Terry Martin Lockheed Martin - Information Technology z/OS z/VM Systems - Performance and Tuning Cell - 443 632-4191 Work - 410 786-0386 terry.ma...@cms.hhs.gov
Re: FTPSERVE on z/VM to z/OS
Do you have an FTP server on z/OS? You don't mention it in your email. From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Martin, Terry R. (CMS/CTR) (CTR) Sent: Wednesday, June 17, 2009 11:32 AM To: IBMVM@LISTSERV.UARK.EDU Subject: FTPSERVE on z/VM to z/OS Hi We have sent up the FTPSERVE in TCP/IP on z/VM 5.3. We tested it going from z/VM to a PC first and it worked fine. My real goal to get it going from the z/VM LPAR to one of my z/OS LPARS directly. I was able to get on my z/OS LPAR and connect to the FTPSERVE on the z/VM LPAR and FTP data fine. The problem is that when I try to go from the z/VM LPAR to the z/OS LPAR it will not connect to the IP of the z/OS LPAR. Is there some kind of routing that I am missing to go from z/VM to z/OS directly? Thank You, Terry Martin Lockheed Martin - Information Technology z/OS z/VM Systems - Performance and Tuning Cell - 443 632-4191 Work - 410 786-0386 terry.ma...@cms.hhs.gov
Re: vswitch for layer 2 network on a second level VM guest
Is this through the same OSA port and what level of VM are you running? From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of russell.gendr...@custserv.com Sent: Wednesday, June 17, 2009 10:56 AM To: IBMVM@LISTSERV.UARK.EDU Subject: vswitch for layer 2 network on a second level VM guest Greetings, Intro We are trying to setup a vswitch for a layer 2 network on a second level VM while sharing the OSA With the level 1 VM. We want to setup the second level VM OSA as a trunk on a layer 2 network for LINUX guests. This is only for testing as we will eventually be setting up multiple OSA's in a trunk on a 1st level VM system on a layer 2 network hosting multiple LINUX guest. This is our goal at any rate. Sorry about the intro to what we are trying to accomplish. Problem. The level 2 VM hangs and the CPU goes to 100% on the level 1 VM and we have to force the 2nd level VM. The command we are trying to use is the following. define vswitch vswf500 rdev f500 controller dtcvsw2 eth vlan 1 portt trunk Thank you Russell Gendreau Time Customer Service, Inc. 813-554-2064
Trace I/O for a 3490 tape drive
Base system is Z/VM 5.4. I'd like to trace all i/o, interrupts, etc for a 3490 tape drive. I am ipl'ing the IPL DDRXA from the S disk and defining the output as 181 3490. The trace set looks like this: NAME VTAP(ACTIVE) 1 I/O FROM - HEX 0181 TERMPRINTRUNSIMCCWIODATA 0008 SKIP 0 PASS 0 STOP 0 STEP 0 CMD NONE My trace command is: CP TRACE IO 181 CCW INS INT BOTH RUN I've used various other combinations of TRACE SIO and TRACE SSSCH and etc... with no happiness. I can get the TSCH and SSCH commands to appear and nothing else. What can I do to get ALL the tape i/o for address 181 to show up? Thanks. Jim Hughes 603-271-5586 It is fun to do the impossible.
TN3270 logon screen
Hi List, I am a complete newbie to TCP/Ip on z/VM - I'm a z/OS-er. We have brought up the TCPIP stack on z/Vm 5.4, and I can logon both unsecure and secure (with SSLSERV). I cannot find out how to set up customised 'USSTABLES' fo r the TN3270 clients - how do you change the z/vm logo, use 'system symbolics' in the table, etc? I am looking at this from a z/os viewpoint. . Could I have different 'USSMSG10' for different ports? I have looked for the TCP/IP redbooks for z/vm 5.4 in vain. Thanks, John Zarzeck
Re: vswitch for layer 2 network on a second level VM guest
Hi Larry, The OSA is defined on the first level VM as attached to the 2nd level VM guest. The OSA address is not defined or in use on the first level VM. The second level VM is 5.4 but I just found out that it does not have the latest PTF's loaded on. So we are doing that as we speak :-) How are you doing Russell Gendreau Time Customer Service, Inc. 813-554-2064 From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Davis, Larry Sent: Wednesday, June 17, 2009 12:17 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: vswitch for layer 2 network on a second level VM guest Is this through the same OSA port and what level of VM are you running? From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of russell.gendr...@custserv.com Sent: Wednesday, June 17, 2009 10:56 AM To: IBMVM@LISTSERV.UARK.EDU Subject: vswitch for layer 2 network on a second level VM guest Greetings, Intro We are trying to setup a vswitch for a layer 2 network on a second level VM while sharing the OSA With the level 1 VM. We want to setup the second level VM OSA as a trunk on a layer 2 network for LINUX guests. This is only for testing as we will eventually be setting up multiple OSA's in a trunk on a 1st level VM system on a layer 2 network hosting multiple LINUX guest. This is our goal at any rate. Sorry about the intro to what we are trying to accomplish. Problem. The level 2 VM hangs and the CPU goes to 100% on the level 1 VM and we have to force the 2nd level VM. The command we are trying to use is the following. define vswitch vswf500 rdev f500 controller dtcvsw2 eth vlan 1 portt trunk Thank you Russell Gendreau Time Customer Service, Inc. 813-554-2064
Re: TN3270 logon screen
Hi, John. Welcome to z/VM! as you've already noticed, there is no VTAM involved here:-) To change the different z/VM logon logos that and end user can see, you can change the LOGO CONFIG file to point to different logo definition files...there can be one logo for each type of 3270 connection to z/VM: 1) locally attached, 2) via TCP/IP (logical device) and 3) via SVM. Each of the logo definition files contains a picture (3270 byte orders) that CP uses to display the z/VM logon screen when a 3270 session connects to the z/VM system via that particular connection method. These files are stored on MAINT's CP PARMS disk at address CF1; and there are several sample LOGO files provided for you to use. There is even a tool, DRAWLOGO, that will help you interactively construct your own logo screen, using extended attributes, colors, etc. This is all documented in the z/VM V5R4.0 CP Planning and Administration manual, chapter 2. John Zarzeck wrote: Hi List, I am a complete newbie to TCP/Ip on z/VM - I'm a z/OS-er. We have brought up the TCPIP stack on z/Vm 5.4, and I can logon both unsecure and secure (with SSLSERV). I cannot find out how to set up customised 'USSTABLES' for the TN3270 clients - how do you change the z/vm logo, use 'system symbolics' in the table, etc? I am looking at this from a z/os viewpoint.. Could I have different 'USSMSG10' for different ports? I have looked for the TCP/IP redbooks for z/vm 5.4 in vain. Thanks, John Zarzeck -- Dave Jones V/Soft www.vsoft-software.com Houston, TX 281.578.7544
Re: TN3270 logon screen
On Wednesday, 06/17/2009 at 01:07 EDT, John Zarzeck john.zarz...@barclays.com wrote: I am a complete newbie to TCP/Ip on z/VM - I'm a z/OS-er. We have brought up the TCPIP stack on z/Vm 5.4, and I can logon both unsecure and secure (with SSLSERV). I cannot find out how to set up customised 'USSTABLES' for the TN3270 clients - how do you change the z/vm logo, use 'system symbolics' in the table, etc? I am looking at this from a z/os viewpoint. Don't. You will get a headache. :-) Logos come from CP and sit on the PARM disk (e.g. MAINT CF1). Look in the CP Planning and Administration book (Chapter 7) for information on setting up a logo. CP can give a different logo to TELNET users than it gives to local non-SNA (OSA-ICC, 2074, 3174, HMC, ...) users if you want. Unlike VTAM USSMSG10, there are no system symbolics in the logos. Note also the reference to the CP REFRESH LOGO command. Could I have different 'USSMSG10' for different ports? Users coming in from different networks can be given different logos ONLY IF they are telnetting to a separate TCPIP stack (e.g. TCPIP2) since CP has no awareness of IP address when it comes to logo selection. [Hmmmthat would make for an interesting Requirement.] I have looked for the TCP/IP redbooks for z/vm 5.4 in vain. You have something far better: People. The entire z/VM Family is here to help. Alan Altmark z/VM Development IBM Endicott
Re: FTPSERVE on z/VM to z/OS
I am not sure but probably not I think it is just a FTP client that I execute in option 6 of ISPF/TSO. Thank You, Terry Martin Lockheed Martin - Information Technology z/OS z/VM Systems - Performance and Tuning Cell - 443 632-4191 Work - 410 786-0386 terry.mar...@cms.hhs.gov mailto:terry.mar...@cms.hhs.gov From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Gentry, Stephen Sent: Wednesday, June 17, 2009 11:39 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: FTPSERVE on z/VM to z/OS Do you have an FTP server on z/OS? You don't mention it in your email. From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Martin, Terry R. (CMS/CTR) (CTR) Sent: Wednesday, June 17, 2009 11:32 AM To: IBMVM@LISTSERV.UARK.EDU Subject: FTPSERVE on z/VM to z/OS Hi We have sent up the FTPSERVE in TCP/IP on z/VM 5.3. We tested it going from z/VM to a PC first and it worked fine. My real goal to get it going from the z/VM LPAR to one of my z/OS LPARS directly. I was able to get on my z/OS LPAR and connect to the FTPSERVE on the z/VM LPAR and FTP data fine. The problem is that when I try to go from the z/VM LPAR to the z/OS LPAR it will not connect to the IP of the z/OS LPAR. Is there some kind of routing that I am missing to go from z/VM to z/OS directly? Thank You, Terry Martin Lockheed Martin - Information Technology z/OS z/VM Systems - Performance and Tuning Cell - 443 632-4191 Work - 410 786-0386 terry.ma...@cms.hhs.gov
Re: TN3270 logon screen
Many thanks, Alan dave :-) -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Alan Altmark Sent: 17 June 2009 18:46 To: IBMVM@LISTSERV.UARK.EDU Subject: Re: TN3270 logon screen On Wednesday, 06/17/2009 at 01:07 EDT, John Zarzeck john.zarz...@barclays.com wrote: I am a complete newbie to TCP/Ip on z/VM - I'm a z/OS-er. We have brought up the TCPIP stack on z/Vm 5.4, and I can logon both unsecure and secure (with SSLSERV). I cannot find out how to set up customised 'USSTABLES' for the TN3270 clients - how do you change the z/vm logo, use 'system symbolics' in the table, etc? I am looking at this from a z/os viewpoint. Don't. You will get a headache. :-) Logos come from CP and sit on the PARM disk (e.g. MAINT CF1). Look in the CP Planning and Administration book (Chapter 7) for information on setting up a logo. CP can give a different logo to TELNET users than it gives to local non-SNA (OSA-ICC, 2074, 3174, HMC, ...) users if you want. Unlike VTAM USSMSG10, there are no system symbolics in the logos. Note also the reference to the CP REFRESH LOGO command. Could I have different 'USSMSG10' for different ports? Users coming in from different networks can be given different logos ONLY IF they are telnetting to a separate TCPIP stack (e.g. TCPIP2) since CP has no awareness of IP address when it comes to logo selection. [Hmmmthat would make for an interesting Requirement.] I have looked for the TCP/IP redbooks for z/vm 5.4 in vain. You have something far better: People. The entire z/VM Family is here to help. Alan Altmark z/VM Development IBM Endicott This e-mail and any attachments are confidential and intended solely for the addressee and may also be privileged or exempt from disclosure under applicable law. If you are not the addressee, or have received this e-mail in error, please notify the sender immediately, delete it from your system and do not copy, disclose or otherwise act upon any part of this e-mail or its attachments. Internet communications are not guaranteed to be secure or virus-free. The Barclays Group does not accept responsibility for any loss arising from unauthorised access to, or interference with, any Internet communications by any third party, or from the transmission of any viruses. Replies to this e-mail may be monitored by the Barclays Group for operational or business reasons. Any opinion or other information in this e-mail or its attachments that does not relate to the business of the Barclays Group is personal to the sender and is not given or endorsed by the Barclays Group. Barclays Bank PLC.Registered in England and Wales (registered no. 1026167). Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom. Barclays Bank PLC is authorised and regulated by the Financial Services Authority.
Re: TN3270 logon screen
There is a DRAWLOGO SAMPEXEC on MAINT (the 191 on my current system, it may have come from somewhere else - I do not remember) that can be copied or renamed DRAWLOGO EXEC. It can be used to create the needed logo file(s). If all you are doing is plain text with no use of colors or highlighting, it is easier to just use XEDIT to create the files. If you want to use the features to make your logo fancy, DRAWLOGO may be the way to go. Regards, Richard Schuh -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Alan Altmark Sent: Wednesday, June 17, 2009 10:46 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: TN3270 logon screen On Wednesday, 06/17/2009 at 01:07 EDT, John Zarzeck john.zarz...@barclays.com wrote: I am a complete newbie to TCP/Ip on z/VM - I'm a z/OS-er. We have brought up the TCPIP stack on z/Vm 5.4, and I can logon both unsecure and secure (with SSLSERV). I cannot find out how to set up customised 'USSTABLES' for the TN3270 clients - how do you change the z/vm logo, use 'system symbolics' in the table, etc? I am looking at this from a z/os viewpoint. Don't. You will get a headache. :-) Logos come from CP and sit on the PARM disk (e.g. MAINT CF1). Look in the CP Planning and Administration book (Chapter 7) for information on setting up a logo. CP can give a different logo to TELNET users than it gives to local non-SNA (OSA-ICC, 2074, 3174, HMC, ...) users if you want. Unlike VTAM USSMSG10, there are no system symbolics in the logos. Note also the reference to the CP REFRESH LOGO command. Could I have different 'USSMSG10' for different ports? Users coming in from different networks can be given different logos ONLY IF they are telnetting to a separate TCPIP stack (e.g. TCPIP2) since CP has no awareness of IP address when it comes to logo selection. [Hmmmthat would make for an interesting Requirement.] I have looked for the TCP/IP redbooks for z/vm 5.4 in vain. You have something far better: People. The entire z/VM Family is here to help. Alan Altmark z/VM Development IBM Endicott
Re: DB2 Problem
Thanks all. Interesting that everyone seems to suggest writing code to get around this problem. I would have thought that there would have been a DB2 method, which I didn't know about, that would, in the same LUW, with a locked DBSPACE, given me the same record selection set for the delete, as was obtained for the insert. Between Repeatable Read and locking the DBSPACE, I thought I should have been given the same selection set within the same LUW. Not a happy camper at this point G. Tom Duerbusch THD Consulting Kevin Corkery kcork...@live.com 6/16/2009 1:03 PM You need to create a delta table. Into an empty delta, select all records of interest from the source table. Insert all records from the delta table to the target table. Use the delta table as a basis for deletion of records from the source table. Not really a DB2 type but I have a similar scenerio with SQLServer and VSAM using ViaSQL; good ol' batch processing mentality at work here :-) -Original Message- From: owner-vs...@lehigh.edu [mailto:owner-vs...@lehigh.edu] On Behalf Of Tom Duerbusch Sent: Tuesday, June 16, 2009 1:38 PM To: VSE Discussion List 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
Re: TN3270 logon screen
On Wednesday, 06/17/2009 at 02:09 EDT, Schuh, Richard rsc...@visa.com wrote: There is a DRAWLOGO SAMPEXEC on MAINT (the 191 on my current system, it may have come from somewhere else - I do not remember) that can be copied or renamed DRAWLOGO EXEC. It can be used to create the needed logo file(s). If all you are doing is plain text with no use of colors or highlighting, it is easier to just use XEDIT to create the files. If you want to use the features to make your logo fancy, DRAWLOGO may be the way to go. Chapter 7 of the CP Planning book discusses DRAWLOGO and includes pointers to to details. Alan Altmark z/VM Development IBM Endicott
Re: Sharing OSA between vm lpars
Thank you for your replies. This is what I was looking for. Bob From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Ronald van der Laan Sent: Monday, June 15, 2009 4:03 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Sharing OSA between vm lpars Bob, No problem. On the z800/z900 and an old OSA microcode level all users needed to be in layer 2 or layer 3 mode, but with the z890/z990 you can mix layer 2 and layer 3 usage. Note that you can also mix layer 2 and layer 3 usage within the same z/VM lpar, for VSWITCHes and/or guests, as long as each user gets its own OSA address triplet. Ronald van der Laan
Re: Trace I/O for a 3490 tape drive
To see all that, you'll probably need the CP TRSOURCE ... TYPE IO... command, et seq. -- Mike Harding z/VM System Support mhard...@us.ibm.com mike.b.hard...@kp.org mikehard...@mindless.com (925) 926-3179 (w) (925) 457-9183 (c) IM: VMBearDad (AIM), mbhcpcvt (Y!) The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU wrote on 06/17/2009 08:58:43 AM: [image removed] Trace I/O for a 3490 tape drive Hughes, Jim to: IBMVM 06/17/2009 10:00 AM Sent by: The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU Please respond to The IBM z/VM Operating System Base system is Z/VM 5.4. I’d like to trace all i/o, interrupts, etc for a 3490 tape drive. I am ipl’ing the IPL DDRXA from the S disk and defining the output as 181 3490. The trace set looks like this: NAME VTAP(ACTIVE) 1 I/O FROM - HEX 0181 TERMPRINTRUNSIMCCWIODATA 0008 SKIP 0 PASS 0 STOP 0 STEP 0 CMD NONE My trace command is: CP TRACE IO 181 CCW INS INT BOTH RUN I’ve used various other combinations of TRACE SIO and TRACE SSSCH and etc… with no happiness. I can get the TSCH and SSCH commands to appear and nothing else. What can I do to get ALL the tape i/o for address 181 to show up? Thanks. Jim Hughes 603-271-5586 It is fun to do the impossible.
Re: Trace I/O for a 3490 tape drive
On Wednesday, 06/17/2009 at 12:58 EDT, Hughes, Jim jim.hug...@doit.nh.gov wrote: I?d like to trace all i/o, interrupts, etc for a 3490 tape drive. ... My trace command is: CP TRACE IO 181 CCW INS INT BOTH RUN I?ve used various other combinations of TRACE SIO and TRACE SSSCH and etc? with no happiness. I can get the TSCH and SSCH commands to appear and nothing else. What can I do to get ALL the tape i/o for address 181 to show up? What other I/O were you expecting? If the guest is in a TSCH loop, it typically won't get I/O interrupts. They will be drained by the TSCH. Alan Altmark z/VM Development IBM Endicott
Re: DB2 Problem
Because that listserv is very much into DB2/zOS and DB2/UDB. There is very little there for DB2/VSE (or DB2/VM). And it is not something that I can problem reportyet. Tom Duerbusch THD Consulting MacIntyre, Cory cory.macint...@navistar.com 6/17/2009 2:16 PM Why don't you ask this question on the DB2 listserv. You might get an answer that is more to your liking. -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Tom Duerbusch Sent: Wednesday, June 17, 2009 1:27 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: DB2 Problem Thanks all. Interesting that everyone seems to suggest writing code to get around this problem. I would have thought that there would have been a DB2 method, which I didn't know about, that would, in the same LUW, with a locked DBSPACE, given me the same record selection set for the delete, as was obtained for the insert. Between Repeatable Read and locking the DBSPACE, I thought I should have been given the same selection set within the same LUW. Not a happy camper at this point G. Tom Duerbusch THD Consulting Kevin Corkery kcork...@live.com 6/16/2009 1:03 PM You need to create a delta table. Into an empty delta, select all records of interest from the source table. Insert all records from the delta table to the target table. Use the delta table as a basis for deletion of records from the source table. Not really a DB2 type but I have a similar scenerio with SQLServer and VSAM using ViaSQL; good ol' batch processing mentality at work here :-) -Original Message- From: owner-vs...@lehigh.edu [mailto:owner-vs...@lehigh.edu] On Behalf Of Tom Duerbusch Sent: Tuesday, June 16, 2009 1:38 PM To: VSE Discussion List 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?
Re: DB2 Problem
Why don't you ask this question on the DB2 listserv. You might get an answer that is more to your liking. -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Tom Duerbusch Sent: Wednesday, June 17, 2009 1:27 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: DB2 Problem Thanks all. Interesting that everyone seems to suggest writing code to get around this problem. I would have thought that there would have been a DB2 method, which I didn't know about, that would, in the same LUW, with a locked DBSPACE, given me the same record selection set for the delete, as was obtained for the insert. Between Repeatable Read and locking the DBSPACE, I thought I should have been given the same selection set within the same LUW. Not a happy camper at this point G. Tom Duerbusch THD Consulting Kevin Corkery kcork...@live.com 6/16/2009 1:03 PM You need to create a delta table. Into an empty delta, select all records of interest from the source table. Insert all records from the delta table to the target table. Use the delta table as a basis for deletion of records from the source table. Not really a DB2 type but I have a similar scenerio with SQLServer and VSAM using ViaSQL; good ol' batch processing mentality at work here :-) -Original Message- From: owner-vs...@lehigh.edu [mailto:owner-vs...@lehigh.edu] On Behalf Of Tom Duerbusch Sent: Tuesday, June 16, 2009 1:38 PM To: VSE Discussion List 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 Disclaimer Confidentiality Notice: This e-mail, and any attachments and/or documents linked to this email, are intended for the addressee and may contain information that is privileged, confidential, proprietary, or otherwise
Re: Trace I/O for a 3490 tape drive
Here is the problem. We are evaluating VTAPE from VSSI. Our VSE machines get Intervention Required when EOT is sensed when running an IDCAMS backup. I am want to organize a trace to a real 3490 tape drive so I can see the behavior when a real 3490 presents EOT to IDCAMS. Then I want to do the same thing using a Virtual tape drive and compare the tape commands and interrupts. If we cannot get beyond this problem with VTAPE, we won't be able to buy the product. The vendor isn't offering much in the way of support so I'm trying to get ahead of the game and give the vendor as much information about the nature of the problem as possible. If you are telling me that I won't see any interrupts or commands using TRSOUCE except for a few xSCH commands, then I am on a fool's errand. Since you know what I am trying to do, perhaps you can recommend a better method. Suggestions welcomed. Jim Hughes 603-271-5586 It is fun to do the impossible. ==-Original Message- ==From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On ==Behalf Of Alan Altmark ==Sent: Wednesday, June 17, 2009 2:25 PM ==To: IBMVM@LISTSERV.UARK.EDU ==Subject: Re: Trace I/O for a 3490 tape drive == ==On Wednesday, 06/17/2009 at 12:58 EDT, Hughes, Jim ==jim.hug...@doit.nh.gov wrote: == I?d like to trace all i/o, interrupts, etc for a 3490 tape drive. ==... == My trace command is: == CP TRACE IO 181 CCW INS INT BOTH RUN == == I?ve used various other combinations of TRACE SIO and TRACE SSSCH and ==etc? == with no happiness. == == I can get the TSCH and SSCH commands to appear and nothing else. == == What can I do to get ALL the tape i/o for address 181 to show up? == ==What other I/O were you expecting? If the guest is in a TSCH loop, it ==typically won't get I/O interrupts. They will be drained by the TSCH. == ==Alan Altmark ==z/VM Development ==IBM Endicott
Re: Trace I/O for a 3490 tape drive
Thanks Mike. I am going down that road right now. How have you been? Jim Hughes 603-271-5586 It is fun to do the impossible. From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Michael Harding Sent: Wednesday, June 17, 2009 2:50 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Trace I/O for a 3490 tape drive To see all that, you'll probably need the CP TRSOURCE ... TYPE IO... command, et seq. -- Mike Harding z/VM System Support mhard...@us.ibm.com mike.b.hard...@kp.org mikehard...@mindless.com (925) 926-3179 (w) (925) 457-9183 (c) IM: VMBearDad (AIM), mbhcpcvt (Y!) The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU wrote on 06/17/2009 08:58:43 AM: [image removed] Trace I/O for a 3490 tape drive Hughes, Jim to: IBMVM 06/17/2009 10:00 AM Sent by: The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU Please respond to The IBM z/VM Operating System Base system is Z/VM 5.4. I'd like to trace all i/o, interrupts, etc for a 3490 tape drive. I am ipl'ing the IPL DDRXA from the S disk and defining the output as 181 3490. The trace set looks like this: NAME VTAP(ACTIVE) 1 I/O FROM - HEX 0181 TERMPRINTRUNSIMCCWIODATA 0008 SKIP 0 PASS 0 STOP 0 STEP 0 CMD NONE My trace command is: CP TRACE IO 181 CCW INS INT BOTH RUN I've used various other combinations of TRACE SIO and TRACE SSSCH and etc... with no happiness. I can get the TSCH and SSCH commands to appear and nothing else. What can I do to get ALL the tape i/o for address 181 to show up? Thanks. Jim Hughes 603-271-5586 It is fun to do the impossible.
Re: vswitch for layer 2 network on a second level VM guest
Post the response to Query Controller Query OSA and QUERY VSWITCH DETAIL Larry From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of russell.gendr...@custserv.com Sent: Wednesday, June 17, 2009 1:04 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: vswitch for layer 2 network on a second level VM guest Hi Larry, The OSA is defined on the first level VM as attached to the 2nd level VM guest. The OSA address is not defined or in use on the first level VM. The second level VM is 5.4 but I just found out that it does not have the latest PTF's loaded on. So we are doing that as we speak :-) How are you doing Russell Gendreau Time Customer Service, Inc. 813-554-2064 From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Davis, Larry Sent: Wednesday, June 17, 2009 12:17 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: vswitch for layer 2 network on a second level VM guest Is this through the same OSA port and what level of VM are you running? From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of russell.gendr...@custserv.com Sent: Wednesday, June 17, 2009 10:56 AM To: IBMVM@LISTSERV.UARK.EDU Subject: vswitch for layer 2 network on a second level VM guest Greetings, Intro We are trying to setup a vswitch for a layer 2 network on a second level VM while sharing the OSA With the level 1 VM. We want to setup the second level VM OSA as a trunk on a layer 2 network for LINUX guests. This is only for testing as we will eventually be setting up multiple OSA's in a trunk on a 1st level VM system on a layer 2 network hosting multiple LINUX guest. This is our goal at any rate. Sorry about the intro to what we are trying to accomplish. Problem. The level 2 VM hangs and the CPU goes to 100% on the level 1 VM and we have to force the 2nd level VM. The command we are trying to use is the following. define vswitch vswf500 rdev f500 controller dtcvsw2 eth vlan 1 portt trunk Thank you Russell Gendreau Time Customer Service, Inc. 813-554-2064
Re: Trace I/O for a 3490 tape drive
You have IPLed DDRXA. It probably is running with interrupts disabled and is using TSCH to determine the status of its I/O. If that is so, all you will see will be the SSCH and TSCH instructions. It is most likely that stand-alone utilities do not want to be distracted by I/O interrupts from extraneous devices, so they may well run with I/O interrupts disabled. It is also likely that they do not want the complexity of having first and second level interrupt handlers, so they use the TSCH loops as Alan suggested. Your trace results are undoubtedly correct and correct. Regards, Richard Schuh -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Alan Altmark Sent: Wednesday, June 17, 2009 11:25 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Trace I/O for a 3490 tape drive On Wednesday, 06/17/2009 at 12:58 EDT, Hughes, Jim jim.hug...@doit.nh.gov wrote: I?d like to trace all i/o, interrupts, etc for a 3490 tape drive. ... My trace command is: CP TRACE IO 181 CCW INS INT BOTH RUN I?ve used various other combinations of TRACE SIO and TRACE SSSCH and etc? with no happiness. I can get the TSCH and SSCH commands to appear and nothing else. What can I do to get ALL the tape i/o for address 181 to show up? What other I/O were you expecting? If the guest is in a TSCH loop, it typically won't get I/O interrupts. They will be drained by the TSCH. Alan Altmark z/VM Development IBM Endicott
Re: FTPSERVE on z/VM to z/OS
Terry, check in SDSF on MVS and see if a stc is running named FTP* something. If it is, then maybe you have a firewall intercepting things. Can you ping the MVS address from VM? Mary Anne On Wed, Jun 17, 2009 at 1:22 PM, Martin, Terry R. (CMS/CTR) (CTR) terry.mar...@cms.hhs.gov wrote: I am not sure but probably not I think it is just a FTP client that I execute in option 6 of ISPF/TSO. *Thank You,* *Terry Martin* *Lockheed Martin - Information Technology* *z/OS z/VM Systems - Performance and Tuning* *Cell - 443 632-4191* *Work - 410 786-0386* *terry.mar...@cms.hhs.gov* terry.mar...@cms.hhs.gov -- *From:* The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] *On Behalf Of *Gentry, Stephen *Sent:* Wednesday, June 17, 2009 11:39 AM *To:* IBMVM@LISTSERV.UARK.EDU *Subject:* Re: FTPSERVE on z/VM to z/OS Do you have an FTP server on z/OS? You don’t mention it in your email. -- *From:* The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] *On Behalf Of *Martin, Terry R. (CMS/CTR) (CTR) *Sent:* Wednesday, June 17, 2009 11:32 AM *To:* IBMVM@LISTSERV.UARK.EDU *Subject:* FTPSERVE on z/VM to z/OS Hi We have sent up the FTPSERVE in TCP/IP on z/VM 5.3. We tested it going from z/VM to a PC first and it worked fine. My real goal to get it going from the z/VM LPAR to one of my z/OS LPARS directly. I was able to get on my z/OS LPAR and connect to the FTPSERVE on the z/VM LPAR and FTP data fine. The problem is that when I try to go from the z/VM LPAR to the z/OS LPAR it will not connect to the IP of the z/OS LPAR. Is there some kind of routing that I am missing to go from z/VM to z/OS directly? *Thank You,* *Terry Martin* *Lockheed Martin - Information Technology* *z/OS z/VM Systems - Performance and Tuning* *Cell - 443 632-4191* *Work - 410 786-0386* *terry.ma...@cms.hhs.gov*
Re: Trace I/O for a 3490 tape drive
TRSOURCE will be difficult to use with VTAPE. There is no real device and I/O is handled by VSSI code. Regards, Richard Schuh From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Hughes, Jim Sent: Wednesday, June 17, 2009 11:54 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Trace I/O for a 3490 tape drive Thanks Mike. I am going down that road right now. How have you been? Jim Hughes 603-271-5586 It is fun to do the impossible. From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Michael Harding Sent: Wednesday, June 17, 2009 2:50 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Trace I/O for a 3490 tape drive To see all that, you'll probably need the CP TRSOURCE ... TYPE IO... command, et seq. -- Mike Harding z/VM System Support mhard...@us.ibm.com mike.b.hard...@kp.org mikehard...@mindless.com (925) 926-3179 (w) (925) 457-9183 (c) IM: VMBearDad (AIM), mbhcpcvt (Y!) The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU wrote on 06/17/2009 08:58:43 AM: [image removed] Trace I/O for a 3490 tape drive Hughes, Jim to: IBMVM 06/17/2009 10:00 AM Sent by: The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU Please respond to The IBM z/VM Operating System Base system is Z/VM 5.4. I'd like to trace all i/o, interrupts, etc for a 3490 tape drive. I am ipl'ing the IPL DDRXA from the S disk and defining the output as 181 3490. The trace set looks like this: NAME VTAP(ACTIVE) 1 I/O FROM - HEX 0181 TERMPRINTRUNSIMCCWIODATA 0008 SKIP 0 PASS 0 STOP 0 STEP 0 CMD NONE My trace command is: CP TRACE IO 181 CCW INS INT BOTH RUN I've used various other combinations of TRACE SIO and TRACE SSSCH and etc... with no happiness. I can get the TSCH and SSCH commands to appear and nothing else. What can I do to get ALL the tape i/o for address 181 to show up? Thanks. Jim Hughes 603-271-5586 It is fun to do the impossible.
Re: Trace I/O for a 3490 tape drive
You will probably find that you must write exit routines to run in your guest. I do not know the capabilities of VSE along those lines, but the MVS line, at least at one time, supported all sorts of different DCB exit routines. At a former job, we had exit routines that wee used in applications where it was critical that they be allowed to continue using another tape. These routines checked to see if the tape was real or VTAPE, and either issued a VTMOUNT (VTAPE) or a VMTAPE MOUNT. I think that you will find that the VSSI product is true to the device being simulated. It is probable that the s/w that interfaces with the device is unaware of VTAPE and tries to get a real tape mounted at EOT. It is not that the device is presenting something different to the O/S (not to IDCAMS), it is that the O/S is unaware that VTAPE is involved. The usual EOT indication is, if my memories are current with today's tape hardware, to present a Unit Exception in the status. What happens beyond that is purely the business of the operating system and access method. Regards, Richard Schuh -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Hughes, Jim Sent: Wednesday, June 17, 2009 12:29 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Trace I/O for a 3490 tape drive Here is the problem. We are evaluating VTAPE from VSSI. Our VSE machines get Intervention Required when EOT is sensed when running an IDCAMS backup. I am want to organize a trace to a real 3490 tape drive so I can see the behavior when a real 3490 presents EOT to IDCAMS. Then I want to do the same thing using a Virtual tape drive and compare the tape commands and interrupts. If we cannot get beyond this problem with VTAPE, we won't be able to buy the product. The vendor isn't offering much in the way of support so I'm trying to get ahead of the game and give the vendor as much information about the nature of the problem as possible. If you are telling me that I won't see any interrupts or commands using TRSOUCE except for a few xSCH commands, then I am on a fool's errand. Since you know what I am trying to do, perhaps you can recommend a better method. Suggestions welcomed. Jim Hughes 603-271-5586 It is fun to do the impossible. ==-Original Message- ==From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On ==Behalf Of Alan Altmark ==Sent: Wednesday, June 17, 2009 2:25 PM ==To: IBMVM@LISTSERV.UARK.EDU ==Subject: Re: Trace I/O for a 3490 tape drive == ==On Wednesday, 06/17/2009 at 12:58 EDT, Hughes, Jim ==jim.hug...@doit.nh.gov wrote: == I?d like to trace all i/o, interrupts, etc for a 3490 tape drive. ==... == My trace command is: == CP TRACE IO 181 CCW INS INT BOTH RUN == == I?ve used various other combinations of TRACE SIO and TRACE SSSCH and ==etc? == with no happiness. == == I can get the TSCH and SSCH commands to appear and nothing else. == == What can I do to get ALL the tape i/o for address 181 to show up? == ==What other I/O were you expecting? If the guest is in a TSCH loop, it ==typically won't get I/O interrupts. They will be drained by the TSCH. == ==Alan Altmark ==z/VM Development ==IBM Endicott
Re: Trace I/O for a 3490 tape drive
On Wednesday, 06/17/2009 at 03:44 EDT, Hughes, Jim jim.hug...@doit.nh.gov wrote: We are evaluating VTAPE from VSSI. Our VSE machines get Intervention Required when EOT is sensed when running an IDCAMS backup. I am want to organize a trace to a real 3490 tape drive so I can see the behavior when a real 3490 presents EOT to IDCAMS. According to the 3490 Hardware Reference, Error Recovery Action code 38 (physical EOT) specifically raises an Equipment Check. Intervention Required can be turned on, too, if the problem is not corrected before the CU presents status to the channel (and I don't know how you recover from EOT). Alan Altmark z/VM Development IBM Endicott
Re: FTPSERVE on z/VM to z/OS
On Wednesday, 06/17/2009 at 11:34 EDT, Martin, Terry R. (CMS/CTR) (CTR) terry.mar...@cms.hhs.gov wrote: We have sent up the FTPSERVE in TCP/IP on z/VM 5.3. We tested it going from z/VM to a PC first and it worked fine. My real goal to get it going from the z/VM LPAR to one of my z/OS LPARS directly. I was able to get on my z/OS LPAR and connect to the FTPSERVE on the z/VM LPAR and FTP data fine. The problem is that when I try to go from the z/VM LPAR to the z/OS LPAR it will not connect to the IP of the z/OS LPAR. Is there some kind of routing that I am missing to go from z/VM to z/OS directly? (You asked a network connectivity question without providing a description of the network. Two demerits.) Watch out for VIPAs. Using NETSTAT command or CHKIPADR exit, discover the IP address of z/OS during a successful FTP. Is that the same IP you use when originating from VM? If you suspect a routing problem, use traceroute on both z/OS and z/VM (TRACERTE) to see what's happening. Alan Altmark z/VM Development IBM Endicott
Re: Trace I/O for a 3490 tape drive
Alan Altmark wrote: According to the 3490 Hardware Reference, Error Recovery Action code 38 (physical EOT) specifically raises an Equipment Check. Intervention Required can be turned on, too, if the problem is not corrected before the CU presents status to the channel (and I don't know how you recover from EOT). Well.. What's odd then would be that VTAPE would present a Physical EOT before having presented a Logical EOT (which is presented by a Unit Exception in the SCSW Device Status on write ops). Otherwise, that would mean that VTAPE isn't emulating the Logical EOT *OR* the virtual tape distance between its Logical EOT and Physical EOT distance is too short - and that within that write, it encountered both Logical and Physical EOTs. Getting passed the logical EOT doesn't end ongoing writes. But any write issued AFTER the logical EOT has passed will incur a UX - this gives the opportunity for any tape writing software to write end of volume information passed the Logical EOT. If writing End Of Volume information (because of a Logical EOT) makes VTAPE run into the Physical EOT then this would happen too. PS : It's theorically possible to correct the problem before the CU presents the status to the channel.. If the channel is exceptionally busy and you run VERY fast to your drive, manually rewind it and make it ready again before the CU has had the opportunity to present the status because of an ongoing long standing working allegiance condition from another CU on that channel... Oh well.. I *DID* say it was theorical ! --Ivan
Re: Trace I/O for a 3490 tape drive
In the MVS world, you tell the Access Method what happened and let it take its EOT path, where it usually mounts the next tape. Regards, Richard Schuh -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Alan Altmark Sent: Wednesday, June 17, 2009 1:34 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Trace I/O for a 3490 tape drive On Wednesday, 06/17/2009 at 03:44 EDT, Hughes, Jim jim.hug...@doit.nh.gov wrote: We are evaluating VTAPE from VSSI. Our VSE machines get Intervention Required when EOT is sensed when running an IDCAMS backup. I am want to organize a trace to a real 3490 tape drive so I can see the behavior when a real 3490 presents EOT to IDCAMS. According to the 3490 Hardware Reference, Error Recovery Action code 38 (physical EOT) specifically raises an Equipment Check. Intervention Required can be turned on, too, if the problem is not corrected before the CU presents status to the channel (and I don't know how you recover from EOT). Alan Altmark z/VM Development IBM Endicott
Re: FTPSERVE on z/VM to z/OS
Hi Mary Anne, No I can not ping the z/OS IP from VM. I think my problem is I do not have an FTP server up on the z/OS side. I will get with the network folks and get that defined and go from there. Thanks! Thank You, Terry Martin Lockheed Martin - Information Technology z/OS z/VM Systems - Performance and Tuning Cell - 443 632-4191 Work - 410 786-0386 terry.mar...@cms.hhs.gov mailto:terry.mar...@cms.hhs.gov From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Mary Anne Matyaz Sent: Wednesday, June 17, 2009 2:19 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: FTPSERVE on z/VM to z/OS Terry, check in SDSF on MVS and see if a stc is running named FTP* something. If it is, then maybe you have a firewall intercepting things. Can you ping the MVS address from VM? Mary Anne On Wed, Jun 17, 2009 at 1:22 PM, Martin, Terry R. (CMS/CTR) (CTR) terry.mar...@cms.hhs.gov wrote: I am not sure but probably not I think it is just a FTP client that I execute in option 6 of ISPF/TSO. Thank You, Terry Martin Lockheed Martin - Information Technology z/OS z/VM Systems - Performance and Tuning Cell - 443 632-4191 Work - 410 786-0386 terry.mar...@cms.hhs.gov mailto:terry.mar...@cms.hhs.gov From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Gentry, Stephen Sent: Wednesday, June 17, 2009 11:39 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: FTPSERVE on z/VM to z/OS Do you have an FTP server on z/OS? You don't mention it in your email. From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Martin, Terry R. (CMS/CTR) (CTR) Sent: Wednesday, June 17, 2009 11:32 AM To: IBMVM@LISTSERV.UARK.EDU Subject: FTPSERVE on z/VM to z/OS Hi We have sent up the FTPSERVE in TCP/IP on z/VM 5.3. We tested it going from z/VM to a PC first and it worked fine. My real goal to get it going from the z/VM LPAR to one of my z/OS LPARS directly. I was able to get on my z/OS LPAR and connect to the FTPSERVE on the z/VM LPAR and FTP data fine. The problem is that when I try to go from the z/VM LPAR to the z/OS LPAR it will not connect to the IP of the z/OS LPAR. Is there some kind of routing that I am missing to go from z/VM to z/OS directly? Thank You, Terry Martin Lockheed Martin - Information Technology z/OS z/VM Systems - Performance and Tuning Cell - 443 632-4191 Work - 410 786-0386 terry.ma...@cms.hhs.gov
Re: FTPSERVE on z/VM to z/OS
Whoops sorry about that Alan. I want to make sure I keep those demerits to a minimum. ☺ Thanks for the information! Thank You, Terry Martin Lockheed Martin - Information Technology z/OS z/VM Systems - Performance and Tuning Cell - 443 632-4191 Work - 410 786-0386 terry.mar...@cms.hhs.gov -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Alan Altmark Sent: Wednesday, June 17, 2009 11:53 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: FTPSERVE on z/VM to z/OS On Wednesday, 06/17/2009 at 11:34 EDT, Martin, Terry R. (CMS/CTR) (CTR) terry.mar...@cms.hhs.gov wrote: We have sent up the FTPSERVE in TCP/IP on z/VM 5.3. We tested it going from z/VM to a PC first and it worked fine. My real goal to get it going from the z/VM LPAR to one of my z/OS LPARS directly. I was able to get on my z/OS LPAR and connect to the FTPSERVE on the z/VM LPAR and FTP data fine. The problem is that when I try to go from the z/VM LPAR to the z/OS LPAR it will not connect to the IP of the z/OS LPAR. Is there some kind of routing that I am missing to go from z/VM to z/OS directly? (You asked a network connectivity question without providing a description of the network. Two demerits.) Watch out for VIPAs. Using NETSTAT command or CHKIPADR exit, discover the IP address of z/OS during a successful FTP. Is that the same IP you use when originating from VM? If you suspect a routing problem, use traceroute on both z/OS and z/VM (TRACERTE) to see what's happening. Alan Altmark z/VM Development IBM Endicott
Re: Trace I/O for a 3490 tape drive
Alan Altmark wrote in part Required can be turned on, too, if the problem is not corrected before the CU presents status to the channel (and I don't know how you recover from EOT) I couldn't say personally, but I have a friend who knew someone who knew a channel who tried to recover by attending group therapy. I think he was a network broadcast channel that was having a tough time dealing with all the new cable channels. Those channel group therapy session now have a growing number of both cable channel and dish network channel members, since many people are beginning to turn to internet channels for entertainment. If you look back in the dark corners of those sad channel group therapy sessions, you may still see a few gray-haired bus tag channel members hobbling around with their canes walkers, but the group is dropping a few bits from even ESCON channel members they age. FICON channels will get their turn some day, too. Is it Friday yet? At least it's CAVMEN (right here at Hewitt Associates) tomorrow! ;-) Mike Walter Hewitt Associates Any opinions expressed herein are mine alone and do not necessarily represent the opinions or policies of Hewitt Associates. The information contained in this e-mail and any accompanying documents may contain information that is confidential or otherwise protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message, including any attachments. Any dissemination, distribution or other use of the contents of this message by anyone other than the intended recipient is strictly prohibited. All messages sent to and from this e-mail address may be monitored as permitted by applicable law and regulations to ensure compliance with our internal policies and to protect our business. E-mails are not secure and cannot be guaranteed to be error free as they can be intercepted, amended, lost or destroyed, or contain viruses. You are deemed to have accepted these risks if you communicate with us by e-mail.
Using DVD to restore an existing z/VM?
Anyone ever use the HMC DVD to write some type of image (DDR? ZIP? whatever) file to restore an existing z/VM system? Not an install - but a restore.. Wondering if this is a possibility if we don't have tape drives on one site but want to restore an image from another site .. something that would be able to restore a couple of 3390-9 images and get us up and running.. Scott
Re: Using DVD to restore an existing z/VM?
I tested dumping a small (5 3390-m9) system using CMSDDR to CMS files, downloading them to a PC, burn to DVD. I took it to a DR exercise, uploaded the files, CMSDDR VMARC and VMARC MODULE to the vendor's floor system and restored my system, one volume at a time. Actual recovery time from sitting at the master console to completing IPL of my system was about 2.5 hours. If I was to do this as a real DR plan, I would have more of MY code on the DVD and prep the floor system so I could run all restores in parallel. /Tom Kern Scott Rohling wrote: Anyone ever use the HMC DVD to write some type of image (DDR? ZIP? whatever) file to restore an existing z/VM system? Not an install - but a restore.. Wondering if this is a possibility if we don't have tape drives on one site but want to restore an image from another site .. something that would be able to restore a couple of 3390-9 images and get us up and running.. Scott
Re: Trace I/O for a 3490 tape drive
Ouch. Jim Hughes 603-271-5586 It is fun to do the impossible. ==-Original Message- ==From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On ==Behalf Of Schuh, Richard ==Sent: Wednesday, June 17, 2009 3:37 PM ==To: IBMVM@LISTSERV.UARK.EDU ==Subject: Re: Trace I/O for a 3490 tape drive == ==You have IPLed DDRXA. It probably is running with interrupts disabled and ==is using TSCH to determine the status of its I/O. If that is so, all you ==will see will be the SSCH and TSCH instructions. It is most likely that ==stand-alone utilities do not want to be distracted by I/O interrupts from ==extraneous devices, so they may well run with I/O interrupts disabled. It ==is also likely that they do not want the complexity of having first and ==second level interrupt handlers, so they use the TSCH loops as Alan ==suggested. == ==Your trace results are undoubtedly correct and correct. == == ==Regards, ==Richard Schuh == == == == -Original Message- == From: The IBM z/VM Operating System == [mailto:ib...@listserv.uark.edu] On Behalf Of Alan Altmark == Sent: Wednesday, June 17, 2009 11:25 AM == To: IBMVM@LISTSERV.UARK.EDU == Subject: Re: Trace I/O for a 3490 tape drive == == On Wednesday, 06/17/2009 at 12:58 EDT, Hughes, Jim == jim.hug...@doit.nh.gov wrote: == I?d like to trace all i/o, interrupts, etc for a 3490 tape drive. == ... == My trace command is: == CP TRACE IO 181 CCW INS INT BOTH RUN == == I?ve used various other combinations of TRACE SIO and TRACE == SSSCH and == etc? == with no happiness. == == I can get the TSCH and SSCH commands to appear and nothing else. == == What can I do to get ALL the tape i/o for address 181 to show up? == == What other I/O were you expecting? If the guest is in a TSCH == loop, it typically won't get I/O interrupts. They will be == drained by the TSCH. == == Alan Altmark == z/VM Development == IBM Endicott ==
Re: Using DVD to restore an existing z/VM?
Gotcha - have done the same thing and it's very handy... but - I'm looking for a solution that doesn't require a running z/VM system..I want to restore the z/VM system from the DVD - much as when you do a z/VM install (which I assume does some type of image restore from images on the DVD?) ... Scott On Wed, Jun 17, 2009 at 5:39 PM, Thomas Kern tlk_sysp...@yahoo.com wrote: I tested dumping a small (5 3390-m9) system using CMSDDR to CMS files, downloading them to a PC, burn to DVD. I took it to a DR exercise, uploaded the files, CMSDDR VMARC and VMARC MODULE to the vendor's floor system and restored my system, one volume at a time. Actual recovery time from sitting at the master console to completing IPL of my system was about 2.5 hours. If I was to do this as a real DR plan, I would have more of MY code on the DVD and prep the floor system so I could run all restores in parallel. /Tom Kern Scott Rohling wrote: Anyone ever use the HMC DVD to write some type of image (DDR? ZIP? whatever) file to restore an existing z/VM system? Not an install - but a restore.. Wondering if this is a possibility if we don't have tape drives on one site but want to restore an image from another site .. something that would be able to restore a couple of 3390-9 images and get us up and running.. Scott
Re: Using DVD to restore an existing z/VM?
There was a thread last August called DDR'ing 3390 DASD To Remote Location. This was using DDR as a pipe stage. The download link is http://www.vm.ibm.com/download/packages/descript.cgi?DRPC During my test on a z/800 IFL engine a 3390 model 3 took 8 minutes to dump 600MB to my local laptop. Another option to look at. Hans -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Thomas Kern Sent: June 17, 2009 7:39 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Using DVD to restore an existing z/VM? I tested dumping a small (5 3390-m9) system using CMSDDR to CMS files, downloading them to a PC, burn to DVD. I took it to a DR exercise, uploaded the files, CMSDDR VMARC and VMARC MODULE to the vendor's floor system and restored my system, one volume at a time. Actual recovery time from sitting at the master console to completing IPL of my system was about 2.5 hours. If I was to do this as a real DR plan, I would have more of MY code on the DVD and prep the floor system so I could run all restores in parallel. /Tom Kern Scott Rohling wrote: Anyone ever use the HMC DVD to write some type of image (DDR? ZIP? whatever) file to restore an existing z/VM system? Not an install - but a restore.. Wondering if this is a possibility if we don't have tape drives on one site but want to restore an image from another site .. something that would be able to restore a couple of 3390-9 images and get us up and running.. Scott
Re: Trace I/O for a 3490 tape drive
You have nailed it Ivan. IDCAMS in VSE write a special block so when IDCAMS is restoring the data, it knows there is another tape. Please don't shoot the messenger. Favor has the same problem as IDCAMS. Doctor D works at EOT. _ Jim Hughes x5586 It is fun to do the impossible. Quote from Walt Disney From: The IBM z/VM Operating System on behalf of Ivan Warren Sent: Wed 6/17/2009 4:56 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Trace I/O for a 3490 tape drive Alan Altmark wrote: According to the 3490 Hardware Reference, Error Recovery Action code 38 (physical EOT) specifically raises an Equipment Check. Intervention Required can be turned on, too, if the problem is not corrected before the CU presents status to the channel (and I don't know how you recover from EOT). Well.. What's odd then would be that VTAPE would present a Physical EOT before having presented a Logical EOT (which is presented by a Unit Exception in the SCSW Device Status on write ops). Otherwise, that would mean that VTAPE isn't emulating the Logical EOT *OR* the virtual tape distance between its Logical EOT and Physical EOT distance is too short - and that within that write, it encountered both Logical and Physical EOTs. Getting passed the logical EOT doesn't end ongoing writes. But any write issued AFTER the logical EOT has passed will incur a UX - this gives the opportunity for any tape writing software to write end of volume information passed the Logical EOT. If writing End Of Volume information (because of a Logical EOT) makes VTAPE run into the Physical EOT then this would happen too. PS : It's theorically possible to correct the problem before the CU presents the status to the channel.. If the channel is exceptionally busy and you run VERY fast to your drive, manually rewind it and make it ready again before the CU has had the opportunity to present the status because of an ongoing long standing working allegiance condition from another CU on that channel... Oh well.. I *DID* say it was theorical ! --Ivan
Re: Trace I/O for a 3490 tape drive
When IDCAMS is run in VSE with a real 3490 tape drive and it reaches EOT, it asks for another tape. Run the same job again and when either the Library Mdisk assigned to the virtual tape volume runs out of space or the SIZE limit assigned to the virtual tape volume is reached, I'd expect IDCAMS to ask for another tape volume. Instead the IDCAMS job aborts with Intervention required. Same program and different results at EOT. I wish the VTAPE support people would talk to us a little more. They are a black hole at this point. We could really use VTAPE in our environment too. _ Jim Hughes x5586 It is fun to do the impossible. Quote from Walt Disney From: The IBM z/VM Operating System on behalf of Schuh, Richard Sent: Wed 6/17/2009 4:08 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Trace I/O for a 3490 tape drive You will probably find that you must write exit routines to run in your guest. I do not know the capabilities of VSE along those lines, but the MVS line, at least at one time, supported all sorts of different DCB exit routines. At a former job, we had exit routines that wee used in applications where it was critical that they be allowed to continue using another tape. These routines checked to see if the tape was real or VTAPE, and either issued a VTMOUNT (VTAPE) or a VMTAPE MOUNT. I think that you will find that the VSSI product is true to the device being simulated. It is probable that the s/w that interfaces with the device is unaware of VTAPE and tries to get a real tape mounted at EOT. It is not that the device is presenting something different to the O/S (not to IDCAMS), it is that the O/S is unaware that VTAPE is involved. The usual EOT indication is, if my memories are current with today's tape hardware, to present a Unit Exception in the status. What happens beyond that is purely the business of the operating system and access method. Regards, Richard Schuh -Original Message- From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Hughes, Jim Sent: Wednesday, June 17, 2009 12:29 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Trace I/O for a 3490 tape drive Here is the problem. We are evaluating VTAPE from VSSI. Our VSE machines get Intervention Required when EOT is sensed when running an IDCAMS backup. I am want to organize a trace to a real 3490 tape drive so I can see the behavior when a real 3490 presents EOT to IDCAMS. Then I want to do the same thing using a Virtual tape drive and compare the tape commands and interrupts. If we cannot get beyond this problem with VTAPE, we won't be able to buy the product. The vendor isn't offering much in the way of support so I'm trying to get ahead of the game and give the vendor as much information about the nature of the problem as possible. If you are telling me that I won't see any interrupts or commands using TRSOUCE except for a few xSCH commands, then I am on a fool's errand. Since you know what I am trying to do, perhaps you can recommend a better method. Suggestions welcomed. Jim Hughes 603-271-5586 It is fun to do the impossible. ==-Original Message- ==From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On ==Behalf Of Alan Altmark ==Sent: Wednesday, June 17, 2009 2:25 PM ==To: IBMVM@LISTSERV.UARK.EDU ==Subject: Re: Trace I/O for a 3490 tape drive == ==On Wednesday, 06/17/2009 at 12:58 EDT, Hughes, Jim ==jim.hug...@doit.nh.gov wrote: == I?d like to trace all i/o, interrupts, etc for a 3490 tape drive. ==... == My trace command is: == CP TRACE IO 181 CCW INS INT BOTH RUN == == I?ve used various other combinations of TRACE SIO and TRACE SSSCH and ==etc? == with no happiness. == == I can get the TSCH and SSCH commands to appear and nothing else. == == What can I do to get ALL the tape i/o for address 181 to show up? == ==What other I/O were you expecting? If the guest is in a TSCH loop, it ==typically won't get I/O interrupts. They will be drained by the TSCH. == ==Alan Altmark ==z/VM Development ==IBM Endicott
Re: DB2 Problem
On Wed, 17 Jun 2009 13:27:17 -0500, Tom Duerbusch duerbus...@stlouiscity .com wrote: Thanks all. Interesting that everyone seems to suggest writing code to get around th is problem. I would have thought that there would have been a DB2 method, which I di dn't know about, that would, in the same LUW, with a locked DBSPACE, given me the same record s election set for the delete, as was obtained for the insert. Between Repeatable Read and locking the DBSPACE, I thought I should have been given the same selection set within the same LUW. Not a happy camper at this point G. Tom Duerbusch THD Consulting I'm a programmer, not a DB2 expert. I think you may need to contact IBM t o find one of them. You didn't explain how you know this is a single LUW. Alan Ackerman Alan (dot) Ackerman (at) Bank of America (dot) com
