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. >
