Is it as simple as needing a "cp set run on"?
Marcy "This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation." ________________________________ From: The IBM z/VM Operating System [mailto:[email protected]] On Behalf Of Scott Rohling Sent: Saturday, May 30, 2009 3:39 PM To: [email protected] Subject: Re: [IBMVM] SECUSER and SEND problem Strange - I would expect the SEND SQLPROD ARCHIVE to result in a HCP150A USER SQLPROD HAS ISSUED A VM READ. Since you didn't get that, I assume the VM READ wasn't issued.. Is it possible the ARCHIVE code knows whether it's disconnected or not and acts differently? Scott On Sat, May 30, 2009 at 4:15 PM, Ed Zell <[email protected]> wrote: I run a series of commands from a CMS user with priv class A to automate my DB/2 for VM database archives. Here is the EXEC: 'CP ATT A91 SQLPROD 181' 'CP SET SECUSER SQLPROD *' 'CP SEND SQLPROD ARCHIVE' 'CP SLEEP 10 SEC' 'CP SEND SQLPROD 181' 'CP SLEEP 60 SEC' 'CP SLEEP 60 SEC' 'CP SLEEP 60 SEC' 'CP SLEEP 60 SEC' 'CP SLEEP 60 SEC' 'CP SLEEP 60 SEC' 'CP SLEEP 60 SEC' 'CP DET A91 SQLPROD' 'CP SET SECUSER SQLPROD OFF' SQLPROD is running disconnected, and once the ARCHIVE command is processed, it goes into a VM READ waiting for the operator to enter the CUU for the tape drive. As long as the user running this is logged on, it works fine. However, if the user is running disconnected, SQLPROD interpets the ARCHIVE command correctly, but then seems to be in a CP read instead of a VM read, and it gives an error on the 181 response. The SQL console log is posted at the end. Once I log on to SQLPROD and press enter, it give me the ARI message and re-prompts me to enter the CUU of the tape drive, which I then key in and it works fine. Is this the way SECUSER and SEND is supposed to work, or should it be the same regardless of whether or not the user issuing the commands is connected? Thanks. Ed Zell Illinois Mutual Life (309) 636-0107 TAPE 0A93 ATTACHED TO SQLPROD 0181 HCPCFX6768I Your SECUSER set to EONBKUP by EONBKUP. ARI0065I Operator command processing is complete. ARI2008I Archive is about to be started. ARI0293I Archive is starting. ARI0239I External labeling of this archive is: Type: database archive Timestamp: 05-30-09 16:13:51 ARI0299A Ready archive output volume. Enter the CUU. HCPCMD001E Unknown CP command: 181 z/VM Version 4 Release 4.0, Service Level 0501 (32-bit), built on IBM Virtualization Technology There is no logmsg data FILES: NO RDR, 0001 PRT, NO PUN RECONNECTED AT 16:16:34 CDT SATURDAY 05/30/09 ARI0297A Response to archive prompt is not valid. ARI0239I External labeling of this archive is: Type: database archive Timestamp: 05-30-09 16:13:51 ARI0299A Ready archive output volume. Enter the CUU. 181 ARI0292I Archive is completed. HCPCFX6768I Your SECUSER set to SQLCONS by EONBKUP. . CONFIDENTIALITY: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you receive this e-mail in error, notify the sender and delete this e-mail from your system.
