Re: DB2 Connect and DB2 V7.5
Hello Ewald, I think the missing OBJECTs with CREATOR of NULLID are from running a BIND from UDB DB2/Connect against a DB2/VM server using DB2??LST. Please check your UDB DB2/Connect PD. However, you also have to run the following 'GRANT's before running the UDB DB2/Connect BIND: CONNECT SQLDBA IDENTIFIED BY SQLDBAPW; SET ERRORMODE CONTINUE; GRANT SELECT ON SYSTEM.SYSCATALOG TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSCOLUMNS TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSINDEXES TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSTABAUTH TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSKEYCOLS TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSINDEXES TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSTABAUTH TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSKEYCOLS TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSSYNONYMS TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSKEYS TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSVIEWS TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSCOLAUTH TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSTEM.SYSPROGAUTH TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSCAT.ROUTINES TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSCAT.INDEXES TO NULLID WITH GRANT OPTION; GRANT SELECT ON SYSCAT.INDEXCOLUSE TO NULLID WITH GRANT OPTION; COMMIT WORK RELEASE; ...Roland --- On Fri, 3/25/11, E. Roller ewald.rol...@rolf-benz.com wrote: From: E. Roller ewald.rol...@rolf-benz.com Subject: DB2 Connect and DB2 V7.5 To: IBMVM@LISTSERV.UARK.EDU Date: Friday, March 25, 2011, 10:54 AM Hi, struggling on with implementing DB2 V7.5, on VM I got some DRDA Problems with DB2 Connect. Environment: Database P1 is on Level 7.3 Database T1 is on Level 7.5 DB2 Connect V7.2 connects to P1 and T1 with no problems DB2 Connect V8.1 connects to P1 with no problems DB2 Connect V8.1 connecting to T1 ends up with errors: Warning: SQL error: [IBM][CLI Driver][SQLDS/VM] SQL0805N Package .NULLID.SYSSN200 was not found. SQLSTATE=51002 , SQL state 51002 in SQLExecDirect in /web/intern/htdocs/archivts/TA0010.php on line 292 Warning: SQL error: [IBM][CLI Driver][SQLDS/VM] SQL0805N Package .NULLID.SYSSN200 was not found. SQLSTATE=51002 , SQL state 51002 in SQLExecDirect in /web/intern/htdocs/archivts/TA0010.php on line 325 The difference of the databases P1 and T1 are in SYSTEM.SYSACCESS table: the old V7.3 fatabase contains the following entries (and some more), I don't know, where they come from: TNAME CREATOR -- --- SYSLN100 NULLID SYSLN101 NULLID SYSLN102 NULLID SYSLN200 NULLID SYSLN201 NULLID SYSLN202 NULLID SYSLN300 NULLID SYSLN301 NULLID SYSLN302 NULLID SYSLN400 NULLID SYSLN401 NULLID SYSLN402 NULLID SYSSN100 NULLID SYSSN101 NULLID SYSSN102 NULLID SYSSN200 NULLID SYSSN201 NULLID SYSSN202 NULLID SYSSN300 NULLID SYSSN301 NULLID In the V7.5 database these entries are missing. Reading the Database Administration Guide, I found out, that I have to set up a Stored Procedure Server for DB2 UDB V8.x connections. This is new with DB2 V7.3, the old database on this level works well without a Stored Proc Server. What do I miss ?? TIA Ewald Roller
Re: Restore DB2 Archive from old release to a newer release database
Hello Ewald, I am afraid it is impossible. You will get msgs: ARI2038E Archive being restored is from a different release of DB2 Server for VM The restore has failed. ARI0032I The database manager has terminated. ARI0043I Database manager return code is 516. Do you still have V7.30 available? If you have, restore using V7.30 and then migrate it to V7.50 is the only way to do so. Regards, ...Roland --- On Thu, 3/17/11, Ewald Roller e.rol...@rolf-benz.de wrote: From: Ewald Roller e.rol...@rolf-benz.de Subject: Restore DB2 Archive from old release to a newer release database To: IBMVM@LISTSERV.UARK.EDU Date: Thursday, March 17, 2011, 12:51 PM Hi, this might be a silly question: is there a way to restore a DB2 ARCHIVE (taken with V7.3) to restore on a newly created DB2 V7.5 Database ? Thanks Ewald Roller
Re: Job opportunity in China
** Cross posted to VSE and VM Lists *** Hello Listers, a Chinese IT consultant firm is trying to recruit 2 to 3 z/OS systems and/or DB2 experts, who can stay in China for long term to provide onsite support to their clients. Preferable who can speak Mandarin. If interested, please contact Mr. Ning LU for further information. His contact information: Lu Ning(吕 宁) Bayshore Consulting and Service Co. 百硕同兴科技(北京)有限公司 Tel:86-10-6439-1733, Fax: 86-10-6439-1582, Mobile: 1370-122-9731, E-Mail: lv_n...@bayss.com Http://www.bayss.com Zhong Chen Building Room 209, No.1 2nd Middle Li Ze Road, Chaoyang District, Beijing, China, 100102 朝阳区利泽中二路1号 中辰大厦 209室,100102
Looking for z/OS DB2 skill
* Cross posted to VSE-L VM-L ** Hello All, this may not be the right forum for z/OS, please let me know where should I send this to. There is a job opportunity for z/OS DB2 + CICS skill to work in BeiJing for 1 year. Option to extend. Please contact me off list if interested. Regards, ...Roland
Re: DB2 stats
Hello Nora, you may want to take a look at the chapter titled: Using the Accounting facility in the DB2 Server for VM - System Administration maual to see if you can make use of the many accounting records DB2/VM generates. Good luck. Regards, ..Roland --- On Wed, 6/30/10, Graves Nora E nora.e.gra...@irs.gov wrote: From: Graves Nora E nora.e.gra...@irs.gov Subject: DB2 stats To: IBMVM@LISTSERV.UARK.EDU Date: Wednesday, June 30, 2010, 1:31 PM We're running DB2 for z/VM release 7.5, under z/VM 5.4. We have a request for database transaction statistics from the planning group. Does anyone know if these are available, and, if so, where they can be found? TIA, Nora Graves nora.e.gra...@irs.gov Main IRS, Room 6531 (202) 622-6735 Fax (202) 622-3123 SE:W:CAR:MP:D:KS:BRSI
Who will be going to WAVV, 2010?
*** Cross posted to VSE and VM Lists *** Hello Listers, I was asked to find out how many DB2 Server for VSE VM customers will be attending the WAVV, 2010. Please respond off list. Thanks. Regards, ...Roland
DB2 Server for VM with VMDSS enabled
Hello DB2 Server for VM users with VMDSS enabled running in z/VM 5.30 and above: VM APAR VM64775 has been opened to address the ARIYI19 09 abends encountered by DB2/VM server running with VMDSS enabled under z/VM 5.30 and above. ERROR DESCRIPTION: An error in pageable PGMBK processing causes segments which may contain changed pages to be skipped. This can lead to changed pages not being saved which in turn can lead to DB2 data corruption. The PTFs are now available: R530 UM32966 R540 UM32967 R610 UM32968 Note that this may happen in a particular workload and in a very heavily loaded (paging rate up to hundred of thousands pages per second) VM system. So far, only couple of customers had reported this kind of abends to IBM. The abends can be avoided by changing the workload. Please review DOC APAR PK73730 for more details. Regards, Roland
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: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
Re: FCOPY help
Ops, Bruce is correct that the FCOPY packlib files are in variable length format. The FCOPY'ed file must have been COPYFILE (PACKed. Then you should PC transfer the file to CMS disk using Binary Fixed 1024, then, COPYFILE (UNP OLDD then, FCOPY fn ft fm (list to find out the members in the paclib (28 of them) then use SEL to fetch the file out to your CMS disk. BTW, you should have a TXT file called CLIVM README for instructions on how to install it. Don't you? Roland --- On Wed, 12/9/09, Bruce Hayden bjhay...@gmail.com wrote: From: Bruce Hayden bjhay...@gmail.com Subject: Re: FCOPY help To: IBMVM@LISTSERV.UARK.EDU Date: Wednesday, December 9, 2009, 8:26 PM FCOPY packlib files are in variable length format, and you lose the record structure when you upload it from a PC. I don't know how you could reconstruct the file in the correct format so that FCOPY would accept it. If the DB2 people would use COPYFILE (PACK on the packlib first, then you could upload as Fixed 1024, use COPYFILE to unpack, then extract the files using FCOPY.
Re: Daylight Saving Time change
I found it in here: ftp://ftp.software.ibm.com/eserver/zseries/zos/vse/pdf3/zvse41/hint9mm2.pdf Rolly Oh, BTW, any one has the time change dates for 2009 - 201x? TIA. --- On Thu, 10/15/09, Shimon Lebowitz shim...@iname.com wrote: From: Shimon Lebowitz shim...@iname.com Subject: Re: Daylight Saving Time change To: IBMVM@LISTSERV.UARK.EDU Received: Thursday, October 15, 2009, 3:09 PM Can you explain where this Hints and Tips is? I told our VSE guy about the AR command, and he said he looked through all the manuals and there is no such animal. Thanks, Shimon Original message Date: Wed, 14 Oct 2009 16:07:26 -0400 From: Edward M Martin emar...@aultman.com Subject: Re: Daylight Saving Time change To: IBMVM@LISTSERV.UARK.EDU Hello Ron, I found it in the Hints and Tips. 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 Ron Schmiedge Sent: Wednesday, October 14, 2009 4:06 PM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: Daylight Saving Time change Where is this AR command documented? On Tue, Oct 13, 2009 at 6:22 PM, Rich Smrcina rsmrc...@wi.rr.com wrote: Jim's process is solid. On the z/VSE web site there is a page that describes what needs to be done during the twice yearly time change (forward and backward). Of course, now I can't find it, apparently it's buried. In a nutshell, after the timezone is set in z/VM, z/VSE can get the new offset with the AR command TIME ZONE=VM.
Re: Daylight Saving Time change
Thanks a lot Mike. Works wonder. Here is my contribution: 2 files based on EST
and EDT for VM VSE.
Rolly
--- On Thu, 10/15/09, Mike Walter mike.wal...@hewitt.com wrote:
From: Mike Walter mike.wal...@hewitt.com
Subject: Re: Daylight Saving Time change
To: IBMVM@LISTSERV.UARK.EDU
Received: Thursday, October 15, 2009, 3:50 PM
...Rolly
Oh, BTW, any one has the time change dates for 2009 - 201x? TIA.
Run the TZDATES EXEC pasted below.
Mike Walter
Hewitt Associates
The opinions expressed herein are mine alone, not my employer's.
/* Prolog; See Epilog for additional information
* Exec Name - TZDATES EXEC *
* Unit Support - OSS/VM *
* Status - Version 2, Release 1.0 *
/
address 'COMMAND'
parse source xos xct xfn xft xfm xcmd xenvir .
parse upper arg parms 1 operands '(' options ')' parmrest
If operands='?' then Signal Explain
parse var operands tz .
If tz='' then tz='C'
ltz=length(tz)
If ltz1 then
Do
say xfn'; Invalid timezone character, length not 1.' ,
'Found 'tzc'.'
say 'For more help, issue:' xfn '?'
Call Exit 20
End
resultfile=xfn 'BOUNDS A'
'FINIS' resultfile
'ERASE' resultfile
Signal ON Error
Do ix=2007 to 2041 /* What years do we want to cover? */
/* As of 2005-09-27, dates beginning in 2042 cause error msg: */
/* HCPZPM6706E Invalid date - 2042-mm-dd */
/* There's time for an APAR before then... */
spring=GetSpring(ix)
fall =GetFall(ix)
'EXECIO 1 DISKW' resultfile '0 F 80 (STRING' spring
'EXECIO 1 DISKW' resultfile '0 F 80 (STRING' fall
End
'FINIS' resultfile
say xfn 'results are now contained in file:' resultfile
Call Exit rc
//
/* Sub-Routines below this point */
//
Exit:
parse arg exitrc .
If verify(exitrc,'-0123456789')=0 then Exit exitrc
else Exit 99
GetSpring:
parse arg year .
/* Find 1st Sunday in March, beginning in 2007 per the: */
/* U.S. Government Energy Policy Act of 2005. */
Do dx=year||0301 by 1 for 7 until dow='Sunday'
dow=date('W',dx,'S')
End
dx=dx+7 /* Ooooh, easy date math! Add 14 for 2nd Sunday in March*/
spring='Timezone_Boundary on' ,
date('S',dx,'S','-') , /* In -mm-dd fmt */
'at 02:00:00 to' tz'DT' /* Change to Daylight Time */
Return spring
GetFall:
parse arg year .
/* Find 1st Sunday in November beginning in 2007 per the: */
/* U.S. Government Energy Policy Act of 2005. */
Do dx=year||1101 by 1 for 7
If date('W',dx,'S')'Sunday' then Iterate
Return 'Timezone_Boundary on' ,
date('S',dx,'S','-') , /* In -mm-dd fmt */
'at 02:00:00 to' tz'ST' /* Change to Standard Time */
End
Return
Error:
say '+++ ERROR error routine entered in:' xfn xft xfm', rc='rc
say '+++ from line:' sigl', which reads:'
say '+++'sourceline(sigl)
Exit 20
Syntax:
say '+++ SYNTAX error routine entered in:' xfn xft xfm', rc='rc
say '+++ from line:' sigl', which reads:'
say '+++'sourceline(sigl)
Call Exit 20
NoValue:
say '+++ NoValue error routine entered in:' xfn xft xfm', rc='rc
say '+++ from line:' sigl', which reads:'
say '+++'sourceline(sigl)
say '+++ Variable with no value is:' condition('Description')
Call Exit 24
Explain:
'PIPE (NAME Explain)' ,
'| ' xfn xft xfm ,
'| INSIDE /ExplainBegin:/ /ExplainEnd:/' ,
'| PREFACE STRLITERAL /'xfn xft xfm 'help.../' ,
'| CONSOLE'
Call Exit 0
/*
ExplainBegin:
Unless changed, TZDATES will produce a file suitable for inclusion in
SYSTEM CONFIG on MAINT's CF1, CF2, etc. disks to define the Spring and
Fall Daylight/Standard timezones.
+-C+
-TZDATES--+--+---
+-timezone-+
+-?+
Where:
timezone
is the first character of the timezone to preface DT or
ST. Default=C, as in CST and CDT.
?
displays this command help.
ExplainEnd:
*/
/* Epilog ***
* Function - See Explain: subrtn above. *
* Component of - z/VM Sysprog's Toolbox. *
* Command format- See Explain: subrtn above. *
* Called by - Prepared z/VM Sysprogs. *
* Dependencies - VM/ESA *
* Program Lang. -
Re: Daylight Saving Time change
Ya. In .TXT format. That is the trick. ;o) Rolly --- On Thu, 10/15/09, Shimon Lebowitz shim...@iname.com wrote: From: Shimon Lebowitz shim...@iname.com Subject: Re: Daylight Saving Time change To: IBMVM@LISTSERV.UARK.EDU Received: Thursday, October 15, 2009, 5:16 PM Hey! You managed to get attachments thru! From: Roland P. Chung roland.ch...@rogers.com Subject: Re: Daylight Saving Time change To: ib...@listserv.uark.edu Thanks a lot Mike. Works wonder. Here is my contribution: 2 files based on EST and EDT for VM VSE. ...Rolly
Unofficial DB2 Servr for VSE VM survey
* Cross posted to VSE-L * Hello Listers, if you are interested, please complete the attached survey. There may be some surprises if you do. Please return the completed survey to db2vs...@ca.ibm.com. Thanks. Roland
Unofficial DB2 Servr for VSE VM survey
Ops, here is the attachement ... * Cross posted to VSE-L * Hello Listers, if you are interested, please complete the attached survey. There may be some surprises if you do. Please return the completed survey to db2vs...@ca.ibm.com. Thanks. Roland
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.com. Thanks. Roland P.S. Found out in a hard way that the List rejects the posting with MS/WORD attachement. Umm
Re: zVM 'disk wiping'
DITTO/VM does that: Process View Options Help -- DITTO/ESA for VM Task Selection Menu Select the desired task or enter a DITTO function code, then press Enter. Use the Menu key to display the menu panel with DITTO function groups. 12 1. Browse data 2. Edit or update data 3. Work with VTOC 4. Work with VSAM catalog 5. Backup/restore CMS files 6. Print data 7. Copy data 8. Locate data 9. Change data 10. Create data 11. Position a tape 12. - Tape Specific Functions -- 13. | | 14. | Select the desired function: | | | | 1. Summarize tape contents | | 2. Print label summary | | 3. Compare two tapes | | | | 4. Write tape marks | | 5. Initialize tape | | 6. Erase tape | | | | F1=Help F3=Exit F12=Cancel | -- Regards, Roland --- On Thu, 10/8/09, Aria Bamdad a...@bsc.gwu.edu wrote: From: Aria Bamdad a...@bsc.gwu.edu Subject: Re: zVM 'disk wiping' To: IBMVM@LISTSERV.UARK.EDU Received: Thursday, October 8, 2009, 5:54 PM It would be nice if the CMS TAPE command had a DSE option. I pass tapes through a degausser but would feel a lot better if I ran a DSE command where the tape was erased from beginning to end. --- snipped ---
Re: more RAM for DB2
Hello Graves, you should only concern with 2 buffer settings: NPAGBUF and NDIRBUF. Especially the NPAGBUF - the more the merrier. DB2 only works on data in its buffers. It will move data from DASD when it does not find what it is looking for in the buffers. So, the more buffer allocated, the better. It may put a drain in the CP's PAGING system if you specify too much. So, work with your SYSPROG to find the balance point. BTW, if you are using VMDSS, please check INFO APAR PK73730. Good luck. ...Roland --- On Tue, 9/1/09, Graves Nora E nora.e.gra...@irs.gov wrote: From: Graves Nora E nora.e.gra...@irs.gov Subject: more RAM for DB2 To: IBMVM@LISTSERV.UARK.EDU Received: Tuesday, September 1, 2009, 3:31 PM Cross-posted to VM/ESA and DB2 lists. I'm running DB2 7.5 under z/VM 5.4 (both are the current releases). We have a brand-new z10 processor. My Systems Programmer has offered me 1 Gig of RAM, up from our current Virtual Storage of 384 Meg for the production database. I'd like to take advantage of this extra RAM, if at all possible. I've been using the Diagnosis Guide to see how to alleviate the problems of not enough storage, thinking that I can work backwards from that. I can see that I've got constraints on my current use of buffers per user, and I can increase that number. I'd like suggestions on other parameters to research, as well. TIA, Nora Graves
Re: Log Analyzer for VM DB2 Server 7.5
Hello Micheal, I don't think there are any free software out there to do what you want because the format of the DB2/VM log disk is IBM Propriety. The closest thing I can think of is the Data Restore for DB2/VSEVM program product which has a LISTLOG function which can provide a list of transactions as part of the restore process. It is NOT free tho. I hope this helps. Regards, ..Roland --- On Thu, 8/27/09, Michael Coffin michaelcof...@mccci.com wrote: From: Michael Coffin michaelcof...@mccci.com Subject: Log Analyzer for VM DB2 Server 7.5 To: IBMVM@LISTSERV.UARK.EDU Received: Thursday, August 27, 2009, 4:20 PM Hi Folks, Does anyone know of a tool for VM DB2 Server 7.5 that would allow you to format the DB2 Server log to see individual transactions? I know z/OS has DB2 Log Analysis: http://www-01.ibm.com/software/data/db2imstools/db2tools/db2lat/ We need something for DB2 Server for VM 7.5, and ideally something free.. :) -TIA -Mike
Running DB2/VM DB Server with VMDSS enabled in z/VM 5.20 and above
Hello Listers, before migrating your DB2/VM DB Server with VMDSS enabled to z/VM 5.20 and above, please order and apply ALL VMDSS related APAR/PTFs. For further information, please review APAR PK73730 or contact DB2/VSEVM Service Team. Thanks. Regards, ...Roland Chung
VM/REXX question on index to an array
Hello Lists, wish you all have a very Merry Christmas and a very Happy New Year!!! May be it has been documented somewhere in a VM/REXX manual, but I am on the road. Let me see who can point clearify this in between turkey dinner and singing Christmas carols. The EXEC . snipped ... TOT = INCARD.0 SAY 'PROCESS 'TOT' LINE FROM INPUT FILE: 'IFN IFT IFM'.' J = 0 /* NUMBER OF OUTPUT DATA ROWS */ indx = 0 /* index to INCARD. */ OLD_DATE = '' /* DATE HOLDING WORKAREA */ PARTN = 'NN' /* partition ID */ DO Indx=1 BY 1 While Indx = TOT If indx 99980 Then do; say indx incard.indx; end; /* LOOK FOR STARTING OF A COUNTER * SET */ /* Counter values AT DATE='06-27-06' TIME='17:31:36' */ CHK = SUBSTR(INCARD.Indx,17,7) IF CHK = 'COUNTER' Then DO CHK = SUBSTR(INCARD.Indx,25,6) /* look for the next string */ IF CHK = 'VALUES' THEN . snipped ... and it went into a loop after the Indx is over 9: . 6 70303 F3 0003 IST878I NUMBER OF QUEUED SESSIONS = 5 22:30:02 12/23/2008 7 70304 F3 0003 IST878I NUMBER OF TOTAL SESSIONS = 125 22:30:02 12/23/2008 8 70305 F3 0003 IST924I - 22:30:02 12/23/2008 9 70306 F3 0003 IST1161I SSCP SESSIONS 22:30:02 12/23/2008 1.E+5 INCARD.1.E+5 1.E+5 INCARD.1.E+5 1.E+5 INCARD.1.E+5 1.E+5 INCARD.1.E+5 1.E+5 INCARD.1.E+5 snipped . Is there a numeric datatype of numeric has a maximum value of 9 when using it in as an index into an array? I have to break the file down into seveal files each on is smaller than 8 records. (yes, 9 will loop too.) Any help is appreciated. TIA ...Roland
Re: DB2 on VM
Hi Aris, that is OK, DB2/VM V7.10 runs well in z/VM 5.30. However, 1) if you are using TCP/IP, make sure that you re-gen the CEEPIPI as documented in Appendix E. IBM Language Environment for VM User Exit Customization for use with TCP/IP in the PD. 2) if you have VMDSS enabled, make sure you have intalled all VMDSS related APARs. a) DB2/VM: - PQ54781 DBSS - SHOW TARGETWS SHOWS WRONG VALUE OF CURRENT WORKING STORAGE WHEN Z/VM IS RUNNING IN 64-BIT MODE. - PQ58880 VMDSS - DURING ROLLBACK, AN 0C8 ABEND IN ARIYT17 COULD OCCUR IF A 2G DATASPACE IS BEING USED. b) z/VM - you have to call z/VM support Good luck. ...Roland - Original Message From: Aria Bamdad [EMAIL PROTECTED] To: IBMVM@LISTSERV.UARK.EDU Sent: Tuesday, August 26, 2008 11:43:18 AM Subject: DB2 on VM Hi List, Anyone using an older version of DB2 for VM on a later version (5) of VM? I am moving to zVM 5.3 and have a DB2 7.1 server that needs to move with it. I want to know if there are any 'problems' running an older 7.1 server on zVM version 5. I would rather not upgrade DB2 if I don't have to. Thanks in advance. Aria
Moving huge volume of data from DB2/VSEVM to DB2/UDB or DB2/LUW
* cross post to VSE-L and VM-L * Hello Lister, here is a piece of information you may want to hear. I have a customer loading data from DB2/VM server to z/Linux server. They use the cross loader method but got very poor performance. I have introduced a difference approach to them. Here is their feedback: === We have had good results with the Data Unload, FTP, and Data Load. We moved 2.5 million records in 22 minutes: the data unload on DB2/VM Server took 15 minutes, the FTP transfer took 5 minutes and the Load on DB2 9.5 took 2 minutes. I don’t know if these numbers can be improved, but they are much better than moving 255,000 records in one hour using the cross loader method. Maybe you want to give this approach a try next time if you want to move a lots of data from DB2/VSEVM server to DB2/UBD or DB2/LUW server. Regards, ...Roland
Sunsetting a 9221
Hello Listers, my customer is sunsetting a 9221-200 with a bank of 9343's emulating 20 3390's. I can think of 3 ways to erase the data from the DASDs: 1) using ICKDSF to TRKFMT them with ERASEDATA parameter; (yeah... very time consuming and CPOWN packs - 4 of them - will be using standalone ICKDSF...) 2) borrow a very power industrial grade magnet (must protect the other recording devices in the computer room. Ummm...); 3) use a 10-LB slug hammer (very quick but messy). Do you guys have better suggesions? Thanks a lot in advance. ...Roland
DB2/VSEVM V7.50 Manuals (PDF format) online
* cross posted to VSE-L and VM-L * Hello Listers, finally, all DB2/VSEVM V7.50 manuals are online at: http://www-1.ibm.com/support/search.wss?rs=66tc=SSEPFBrank=8dc=DA410+DA450dtm Regards, ...Roland
DB2/VSEVM V7.50 manuals
Hi Listers, DB2/VSEVM V7.50 manuals are online at: http://www-306.ibm.com/software/data/db2/vse-vm/directory.html Regards, ...Roland
Re: Live Virtual Class, Aug 14 - Virtualization Basics (10am NY time)
Thanks Rob, I tried again just now. I was able to register. Regards, ..Roland Rob van der Heij [EMAIL PROTECTED] wrote: On 8/12/07, Roland P. Chung wrote: It does not matter any more It is full when I tried to register on Friday afternoon... Ummm Try again. There may have been a glitch since it picked up a new registration just now. Rob -- Rob van der Heij Velocity Software, Inc http://velocitysoftware.com/
Re: Live Virtual Class, Aug 14 - Virtualization Basics (10am NY time)
It does not matter any more It is full when I tried to register on Friday afternoon... Ummm ...Roland Alan Ackerman [EMAIL PROTECTED] wrote: On Wed, 8 Aug 2007 16:24:31 -0400, Pamela Christina in warm sunny Endicott NY wrote: This 90-minute LVC will be conducted on Tuesday, August 14 starting at 10:00 Eastern U.S./4:00 p.m. CET and recorded for subsequent replay. The replay will be available 1 week after the live session via a link on the z/VM website (http://www.vm.ibm.com/) Is this really worth getting up at 7 am Pacific time? Important: Enroll for this session by EOD Monday, August 13 with this URL: https://asp22.centra.com:443/Reg/main/00013c73780113c2f41183002cd1/en_US There is no tuition to participate in this session, however you must enroll at least 1 business day ahead of the session date to enable your participation. The LVC will be delivered using the Centra tool that employs Voice over IP (VoIP) technology to provide both the audio as well as the visuals to your Windows workstation. Each participant must enroll individually, ie. no sharing of LVC logins is supported. After enrolling in the LVC, you should run a a System Check via the following URL to verify your workstation meets the following minimum requirements. System Check: https://stg.centra.com/SysCheck/main/Customers/ibmstg Windows 2000 or Windows XP Internet Explorer 5.01, Netscape 7.2, Firefox 1.0 or later. 28.8 kbps or faster Internet connection P350+ MHz, 128+ MB memory 800x600 16-bit color display or better sound card and speakers (to hear the audio portion of the LVC) microphone (required if you want to ask a question during the LVC) What is the Centra tool? I don't have a microphone. Will the replay also require the Centra tool? I gather it wants to install something on my PC, and that it will not work on my Mac. Why? I'm not convinced this is worth all the trouble to install a piece of software. Let me know what kind of turnout you get. I think you are setting the bar too high.
SSH in TCP/IP for VM
Hello Listers, could any one tell me in which release of TCP/IP for VM SSH is available? TIA ...Roland
Re: SSH in TCP/IP for VM
Thanks Alan. I will talk to the customer about that. ...Roland Alan Altmark [EMAIL PROTECTED] wrote: On Tuesday, 07/31/2007 at 12:21 EDT, Roland P. Chung wrote: Hello Listers, could any one tell me in which release of TCP/IP for VM SSH is available? TIA There is no IBM-provided SSH server or client for z/VM. --snipped -- Alan Altmark z/VM Development IBM Endicott
Re: RXSQL talking to DB2 UDB on Linux/IFL
Hello Ed, there is a problem using RXSQL to run against DB2 for z/OS V8: Getting SQLCODE -301 when inserting undefined variable (never assigned a value or RXSQL DROPped) to DB2 for z/OS V8. When a variable was undefined, it was considered to have a NULL value. The application works fine with DB2 for z/OS V7 but failed with SQLCODE -301 with DB2 for z/OS V8. The reason being: Prior to DB2 for z/OS V8 when an indicator variable is set to a negative number that indicates that you are specifying NULL value. The value of the actual variable did not matter when indicator variable is negative. DB2 for Z/OS V8 has added an extra restriction: the value of the actual variable must have a valid value. I understood UDB LUW has adopted the same changes in V8. So, you have to watch out for that. A temporary RXSQL FIX has been provided to circumvent the customer's situation. Contact DB2/VSEVM support if you encounter similiar problem. Other than that, all RXSQL application running against DB2 for z/OS are fine. I hope this helps. ...Roland Ed Zell [EMAIL PROTECTED] wrote: We are looking at a Z series box and the possibility of getting off DB/2 for VM and moving it to DB/2 UDB which would run under Linux on an IFL. Is anyone doing this and using RXSQL on VM to access the DB/2 UDB database? We have a couple of custom applications that depend on RXSQL and need to make sure that this environment would be viable and supported. Thanks. Ed Zell Illinois Mutual Life (309) 674-8255 x-107 . CONFIDENTIAL NOTICE: This communication, including any attachments, is intended only for the use of the individual or entity to which it is addressed and contains information which may be confidential. If you are not the intended recipient, any distribution or copying of this communication is strictly prohibited. If you have received this communication in error, notify the sender immediately, delete the communication and destroy all copies. Thank you for your compliance. With best regards, ...Roland Chung Senior Technical Specialist (S/390,VM/VSE,DB2/VSEVM) MAXC Consultants Inc. Voice/Fax: 416-901-9442 (If busy, call: 416-469-2268) 197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6 ** Live simply. Love generously. Care deeply. Speak kindly. Leave the rest to God. I think this is something we should all live by. - An Old Farmer's Advice **
SQL/DS VM V3.50 question
Greeting Listers, are there any one out there running SQL/DS VM V3.50? If he/she is, what level of VM? Thanks a lot in advance. With best regards, ...Roland Chung Senior Technical Specialist (S/390,VM/VSE,DB2/VSEVM) MAXC Consultants Inc. Voice/Fax: 416-901-9442 (If busy, call: 416-469-2268) 197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6 ** Live simply. Love generously. Care deeply. Speak kindly. Leave the rest to God. I think this is something we should all live by. - An Old Farmer's Advice **
Caution: user migrating DB2/VM server to z/VM 5.20 running in z9 hardware with VMDSS enabled
To all DB2/VM server users: several instances of DB2/VM server abends with ARIYI36 05 have been reported to IBM lately when users migrated their DB2/VM servers to z/VM 5.20 running in a z9 hardware with VMDSS enabled. VM APAR VM63968 has been opened to address this problem. IBM z/VM development is currently, with the assistance of DB2 for VSEVM Team, testing the fix for VM APAR VM63968. DB2/VM server's ARIYI36 05 abend is an after the fact situation. That means, DB2/VM server detects an inconsistance between the BDISK and the DBEXTENT when it requests CP to bring in a datapage from the DBEXTENT. With VMDSS support enabled, CP is responsible to move datapage between DASD(DBEXTENT) and dataspace then DB2/VM server moves the datapage from dataspace to its buffer for processing.The error could have been: 1) CP returns an incorrect datapage 2) the datapage returned has been previously stored on DASD incorrectly by CP If a user would like to migrate DB2/VM server to z/VM 5.20 running in a z9 hardware BEFORE the official PTF for APAR VM63968 is available, the recommendation is: 1) apply all available MCLs to z9 box; 2) apply all current VM APARs/PTFs, especially VM63978/UM31822; 3) disable VMDSS support in DB2/VM server; 4) if not possible to disable VMDSS support in DB2/VM server, the DB2/VM server should be archived more frequency. With best regards, ...Roland Chung Senior Technical Specialist (S/390,VM/VSE,DB2/VSEVM) MAXC Consultants Inc. Voice/Fax: 416-901-9442 (If busy, call: 416-469-2268) 197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6 ** Life is short. Stop once in a while and smell the roses. **
Re: JDBC and DB2/VM
Hello Herny, one of my clients was able to access DB2/VSE from MS/Excel after installing the appropriate "Schema stored procedures for CLI/ODBC/JDBC/OLE DB Client Applications" fix. (BTW, it never made to be an APAR).Have you instlled the "Schema stored procedures for CLI/ODBC/JDBC/OLE DB Client Applications"fix in your DB2/VM system? If not, I would suggest you call IBM DB2/VSEVM services to order:1)any missing APAR/PTFs for your DB2/VM V7.20 system. 2) request to have a"Schema stored procedures for CLI/ODBC/JDBC/OLE DB Client Applications"FIXTEST. 3) install the above and try again.I know you will not get too much support from IBM because DB2/VM V7.20 is out of services. However, you still can get all existingAPAR/PTF/FIXes, etc. for DB2/VSE 7.20.Good luck. ...Roland Henry Wilusz [EMAIL PROTECTED] wrote: HelloJust a short question to see if anyone has gotten JDBC drivers on awindows machine to successfully access DB2/VM. We know that the driverswork with DB2/universal. but fail miserably with DB2/VM. DB2/VM is atversion 7.2The attempt to access DB2/VM returns a authorization failure message tothe windows machine (incorrect message there) and a data capture dump onDB2/VM. The reason for exploring the JDBC angle is that ODBC connections tothis database sometimes hang with no error messages, and we cannot seemto reproduce the hang conditions. An interesting part of the DB2 dump is below. Note that the probablecause section does not tell what the unsupported value was that it istrying to deal with.SYMPTOM STRING: MS/ARI2909I PIDS/5697F4201 RIDS/ARITPAC PRCS/11PROBABLE CAUSE OF FAILURE:DDM VALUE NOT SUPPORTEDIf anyone has gotten cold fusion or JDBC to work to DB2/VM, and iswilling to share the secrets, I would like to hear from them thanks Henry Wilusz[EMAIL PROTECTED]Failure is not an option . . . . .. . . . . It comes standard with windowsWith best regards,...Roland ChungSenior Technical Specialist (S/390,VM/VSE,DB2/VSEVM)MAXC Consultants Inc.Voice/Fax: 416-901-9442 (If busy, call: 416-469-2268)197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6** Life is short. Stop once in a while and smell the roses. **
Re: DB2 VM Deleted DBSPACES marked with NOT symbol
Hi Steve, I do not do too much in the Windows environment. I know of some customers are using the WindowsODBC supportin Excel via DB2/Connect to get access to DB2/VSEVM database servers. DB2/VSEVM provides a set of CLI Stored Procedures to supportODBC.It works not too badly.If you are getting various user id errors whenyou aretrying to access table data then you may want to look at what the user ID your Windows applicationis passing. Onceyou have connected to your DB2/VM database from Windows, issue a SHOW CONNECT to find out the SQLID your Windows user is using. Tha may give you a clue. Make sure the SQLID is authorized to access the targettable. Sorry, can't provide much help.Regards, ...RolandSteve_Domarski/[EMAIL PROTECTED] wrote: Roland, While I got your attention. Do you know of a ODBC driver or ADO.NETpackage that will communicate with VM/DB2 from a Windows .NET application.I've been to Direct Connect and can connect to VM but I get various user iderrors when I try to access table data.Steve Domarski 352-368-8350Property Appraisers Office Marion County Florida USAWith best regards,...Roland ChungSenior Technical Specialist (S/390,VM/VSE,DB2/VSEVM)MAXC Consultants Inc.Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268)197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6** Life is short. Stop once in a while and smell the roses. **
Re: DB2 VM Deleted DBSPACES marked with NOT symbol
Hi Steve, please do a SELECT * FROM SYSTEM.SYSDROP and post the output. Thanks.Steve_Domarski/[EMAIL PROTECTED] wrote: I recently had a pool fill up leaving only 20 pages left. I decided to movesome of the DBSpaces to another pool. All went well but the DBSpaces Imoved were not cleared in the "SELECT * FROM SYSTEM.SYSDBSPACES" list forthe pool I took them from. The DBSpaces dropped now have eight NOT symbolsas the owner name and 5 leading spaces and the DBSpaces number as a DBSpacename. They are no-longer accessible for use. I was able to resolve thespace problem by adding another extent to the pool but the DBSpaces arestill inaccessible.I found the DBSPNUM startup parm in the Operations guide that indicatedthat I needed to use STARTUP mode P and SYSMODE S. I did that for DBSPNUM =* as well as specific DBSpace numbers no relief.Does anyone have any other ideas.Steve Domarski 352-368-8350Property Appraisers Office Marion County Florida USA"Great minds discuss Ideas.Average minds discuss events.Small minds discuss people. " - Admiral Hyman RickoverWith best regards,...Roland ChungSenior Technical Specialist (S/390,VM/VSE,DB2/VSEVM)MAXC Consultants Inc.Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268)197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6** Life is short. Stop once in a while and smell the roses. **
Re: IOCP for MP2003-204
Hello all Listers, thanks to all. I think I should let you guys know the outcome of this project. With an IBM ROC helping me all afternoon yesterday, we finally conclued that it may be because of VM/ESA 2.30 is lecking maintenances to be able to handle the newer hardware (MP2003 and IBM 2105-F20 Shark). The VM was been instlled sometimes in October, 1998 and have no services applied to it since. Talking about stable - VM is the best. No matter how we twisted the IOCDS, we were getting the exact DISABLED WAIT PSW. We felt that when CP sends out the reset to all the channels when IPLed, it went into DISABLED WAIT because it does not understands the return code coming back from the channel/hardware. This is a great experience for me to be involved in the middle of a 'lack of planning', 'cold turkey' CPU upgrade project. They backs up the old O/S DASDs, shuts down the old system, rolls in and installs the new hardware, and starts restore. Hopefully the system would run just like in the new hardware. No parallel...no testing... Ummm. We recommanded to upgrade to VVM 4.40 and try again. This time, I will do all the needed preparation before I drop in again. That is enough. I have been taken up a lot of the bandwidth in this List lately. Thanks again for all the help. You guys are the greatest! Regards, ...Roland --- Roland P. Chung [EMAIL PROTECTED] wrote: Hi George, I have 5 CPOWNED volumes. I have used ICKDSF to formated and DDR restored them all. The other 59 DASDs are for user DATA. I just put a volume number on. The DISABLE WAIT PSW is 000A9025 - and the explaination is; SCP initialiated reset of the I/O interface. Maybe something I should not have included in the IOCDS? Let me check. Regards, ...Roland George Haddad [EMAIL PROTECTED] wrote: If any - snipped --
Re: We need a copy of z/VM 4.40 installation tape for 3390 system
Hi Tom, yes, only the support part. But for z/VM 4.40, it will be Out of Services on Sept. 30, 2006. Maybe you want to act fast.Regards,...RolandTom Duerbusch [EMAIL PROTECTED] wrote: That is interesting.Apparently, IBM (VM group) is no longer supporting 31 bit hardware. Itseems to me that IBM always kept the last release of an OS available fora particular hardware platform available for order. Perhaps it is justsupported.I have a MP3000 client, that I have been hinting that VM would besomething they need to look at, again. If z/VM 4.x isn't available andz/VM 5.x doesn't support 31 bit hardware, I need to do some backtracking.Tom DuerbuschTHD Consulting [EMAIL PROTECTED] 6/20/2006 10:03 AM Hello Listers, sorry to bother you guys again.We called IBM software to order z/VM 4.40. However, the rep. said itwas out of marketing since March 2006. He can't ship it to us. But, hesaid, if we can get a copy of the distribution tape, IBM will licence itfor us.Please contact me off-list if you are willing to lend a copy of thedistribution tape for z/VM 4.40 for 3390 system. Greatly appreciated. With best regards,...Roland ChungSenior Technical Specialist (S/390,VM/VSE,DB2/VSEVM)MAXC Consultants Inc.Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268)197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6** Life is short. Stop once in a while and smell the roses. **
Re: We need a copy of z/VM 4.40 installation tape for 3390 system
Hello Jim, great news!However, at the conference call, IBM rep. said "...I will licence the product ifyou can get a copy of z/VM distribution tape from somewhere else". However, he also said "(getting a copy other than from IBM)... is not condomed nor recommended."That is the "official" position of IBM. So, I am afraid you wouldn't get an "official" OK from IBM. Thanks for your offering.Regards,...Roland"Dodds, Jim" [EMAIL PROTECTED] wrote: We have the z/VM 4.4 Tapes but would need something from IBM saying it was ok for us to copy and give to you. Jim Dodds Systems Programmer Kentucky State University 400 East Main Street Frankfort, Ky 40601 502 597 6114From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of Roland P. ChungSent: Tuesday, June 20, 2006 11:04 AMTo: IBMVM@LISTSERV.UARK.EDUSubject: We need a copy of z/VM 4.40 installation tape for 3390 system Hello Listers, sorry to bother you guys again.We called IBM software to order z/VM 4.40. However, the rep. said itwas out of marketing since March 2006. He can'tship itto us. But, he said, if we can get a copy of thedistribution tape, IBM will licence it for us.Please contact me off-list if you are willing to lend a copy of the distribution tape forz/VM 4.40 for 3390 system.Greatly appreciated. With best regards,...Roland ChungSenior Technical Specialist (S/390,VM/VSE,DB2/VSEVM)MAXC Consultants Inc.Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268)197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6** Life is short. Stop once in a while and smell the roses. **
Re: We need a copy of z/VM 4.40 installation tape for 3390 system
Well, that is IBM. Reading between the lines: customer cannot order a copy of z/VM 4.40 because it has been pulled from marketing. The system just don't accept the order. But, if the customer can get a copy from other places, IBM will let the customer uses it as long as the customer registers the software with IBM and is paying the licence fee. IBM wouldn't ask where the customer obtained the copy from. ... this pratice (of getting a copy of the software from other customer other than from IBM) is neither recommended or condomed (by us). So, any taker? I promise I wouldn't tell IBM you give me a copy of z/VM 4.40. I also promise my customer would register with IBM and pay the licensing fee. Please contact me off-list. TIA. It will be greatly appreciated. Regards, ...Roland --- Schuh, Richard [EMAIL PROTECTED] wrote: It seems to me that permission to get implies permission to send. However, I don't think the stated permission to get is official, and probably cannot be thought reliable unless stated in writing and signed by the appropriate people. Let us know when you get that :-) Regards, Richard Schuh -Original Message- From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] Behalf Of Michael Coffin Sent: Tuesday, June 20, 2006 11:56 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: We need a copy of z/VM 4.40 installation tape for 3390 system I'm confused, IBM said they'd license z/VM 4.4.0 for you if you could get a copy of the installation tape from another customer, but won't permit other customers to send you a copy of the tape. Am I understanding the situation correctly? IF permission to borrow an existing customer's tape(s) can be obtained from IBM, I may be able to help. Michael Coffin, President MC Consulting Company, Inc. 57 Tamarack Drive Stoughton, Massachusetts 02072 Voice: (781) 344-9837FAX: (781) 344-7683 [EMAIL PROTECTED] www.mccci.com http://www.mccci.com/ We employ aggressive SPAM filters. If you cannot reply or send email to mccci.com go to www.mccci.com/spamblockremove.php http://www.spamabuse.org/images/anti-spam.gif -Original Message- From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of Dodds, Jim Sent: Tuesday, June 20, 2006 11:13 AM To: IBMVM@LISTSERV.UARK.EDU Subject: Re: We need a copy of z/VM 4.40 installation tape for 3390 system We have the z/VM 4.4 Tapes but would need something from IBM saying it was ok for us to copy and give to you. Jim Dodds Systems Programmer Kentucky State University 400 East Main Street Frankfort, Ky 40601 502 597 6114 _ From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of Roland P. Chung Sent: Tuesday, June 20, 2006 11:04 AM To: IBMVM@LISTSERV.UARK.EDU Subject: We need a copy of z/VM 4.40 installation tape for 3390 system Hello Listers, sorry to bother you guys again. We called IBM software to order z/VM 4.40. However, the rep. said it was out of marketing since March 2006. He can't ship it to us. But, he said, if we can get a copy of the distribution tape, IBM will licence it for us. Please contact me off-list if you are willing to lend a copy of the distribution tape for z/VM 4.40 for 3390 system. Greatly appreciated. With best regards, ...Roland Chung Senior Technical Specialist (S/390,VM/VSE,DB2/VSEVM) MAXC Consultants Inc. Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268) 197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6 ** Life is short. Stop once in a while and smell the roses. **
Re: IOCP for MP2003-204
Hi All, thanks for all your responses. How could I forget the SAPL. Must be getting old The customer is still using VM/ESA 2.30... I don't know if the SAPL would take the LOADPARM. Anyway, the application runing on the MP2003-204 allows a place to put in a load address and a load parameter. However, it only allows 8 characters in this load parameter field, but NO special characters allows, like the = sign... RRRrr..There are no "intergrated console support" in this beast either Do you have other suggestions? TIARegards,...RolandKris Buelens [EMAIL PROTECTED] wrote: In some z/VM release, new possibilities have been added in the area of console address override. I don't know which release, but it surely already work in z/VM 4.4 Here's a summary of what you now can do - LOADPARM rdev -- starts SAPL on "rdev", there you can enter CONS=rdev to tell CP where to go and load CP - LOADPARM CONSrdev - SAPL directly loads CP and passes CONS=rdev As rdev one can also specify SYSG to indicate the "integrated 3270 CONSOLE", very easy but first you must drag a "3270 console" icon on the icon of the LPAR in which you want to load VM. Both SAPLand CP support this console (z/OS does not), so the LOADPARM can be SYSG or CONSSYSG Similar, there is SYSC, the integrated linemode console, not supported by SAPL, so you can also enter LOADPARM CONSSYSC to directly load CP and instruct it to got to that linemode terminal. Kris,IBM Belgium, VM customer support
Re: IOCP for MP2003-204
Thanks George I over the hump right now... I managed to get a IOCDS created on Sunday that gave me access to the tape, 3278'sand DASDs.Now, Iam tying to load the CP. It is not cooperating yet. Nowhere to check why it went into DISABLE WAIT! Maybe because I was to lazy to type in all thecommand using the standalone ICKDSF. I have not initialized all the other 59 3390-3 and CP is getting upset. I am in the process of using ICKDSF to do a quick initialize putting a volume seriam number on these DASDs and try again. Wish me luck.This is a classic case of "lack of planning and totally reflected on me" ^e^ ...Thanks again...RolandGeorge Haddad [EMAIL PROTECTED] wrote: I believe I mis-spoke in my prev email, it is the CUNUMBR field on the CNTLUNIT macro that we use to re-define our CHPIDs to "more desirable" numbers.With best regards,...Roland ChungSenior Technical Specialist (S/390,VM/VSE,DB2/VSEVM)MAXC Consultants Inc.Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268)197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6** Life is short. Stop once in a while and smell the roses. **
Re: IOCP for MP2003-204
Hi George, I have 5 CPOWNED volumes. I have used ICKDSF to formated and DDR restored them all. The other 59 DASDs are for user DATA. I just put a volume number on.The DISABLE WAIT PSW is 000A9025 - and the explaination is; "SCP initialiated reset of the I/O interface".Maybe something I should not have included in theIOCDS? Let me check.Regards,...RolandGeorge Haddad [EMAIL PROTECTED] wrote: If any of these DASD are in your CP-owned list, be sure to FORMAT the CP areas as well as defining the Labels. Especially if they are PAGE areas. Bad things have happened to us in the past trying to page to an un-formatted area.As another poster said, please pass on your Disabled Wait PSW as that will most likely pinpoint your current woes.Roland P. Chung wrote: Thanks George I over the hump right now... I managed to get a IOCDS created on Sunday that gave me access to the tape, 3278's and DASDs. Now, I am tying to load the CP. It is not cooperating yet. Nowhere to check why it went into DISABLE WAIT! Maybe because I was to lazy to type in all the command using the standalone ICKDSF. I have not initialized all the other 59 3390-3 and CP is getting upset. I am in the process of using ICKDSF to do a quick initialize putting a volume seriam number on these DASDs and try again. Wish me luck. This is a classic case of "lack of planning and totally reflected on me" ^e^ ... Thanks again. ..Roland
Re: IOCP for MP2003-204
Hello All, thanks to all who responded. After hours of struggling, I manage to set up a IOCDS which I was able to get at the tape drives, DASDs and 3174. IPLed the standalone ICKDSF and DDR. I was very happy to be able to restore all 5 CP OWNED volumes. Came to the monent of truth IPL'ed VM hit the terminal... nothing... After spent hours investigating and trial many different address on the 3174, I only can figure out that VM can't get at the 3174 because in the SYSTEM CONFIG file, it says: Operator_Consoles 001F 0020 0021 0022 0023 Emergency_Message_Consoles 0020 0021 0022 0023 And in MP2003 world, I think there are no channel 0 anymore and there re no good old 01F(the integrated console) hangs on that channel either. I think the address (at least the UU) has been hardcoded as 40-5F on the 3174 controler. I was very tire my brian can only think of a few solutions: 1) find an IBM Productivity Centre near Washinging, DC (if there are such thing in US!), restore the 5 pack VM system, IPL it and fix the SYSTEM CONFIG to include 040 - 043 (the address on that 3174); Backup the 230RES, restore it back here and I should be in business 2) reconfigure the 3174 to start the UU from 20 - well, the Utility and a backup disk are there only thing I need is a manual. Anyone has a LINK I can get a softcopy? 3) get a zVM DVD? How and where? Anyone has a better idea on how to resolve this problem? TIA Regards, ...Roland --- Alan Altmark [EMAIL PROTECTED] wrote: On Friday, 06/16/2006 at 09:46 AST, George Haddad [EMAIL PROTECTED] wrote: Our 2003-205 can be IMLed to do Dynamic I/O. We never did implement that feature --- we just never made many I/O changes over the yrs -- so I don't know if that negates the need for an inital IOCDS load or not. No, it doesn't. To IPL CP you have to IPL *something*. That *something* must be in the active I/O configuration. You need a tape drive and enough dasd volumes to restore a basic VM system, plus a console. This is the nice thing about having an emergency 1-pack micro-system. Sysres, paging, spooling, a directory, OPERATOR and MAINT, DDR, IOCP, all on one volume, with the console pointing to the integrated console (on modern machines, integrated 3270). Or, also on modern machines, the ability to IPL the z/VM DVD. IF you authorized the LPAR to perform dynamic I/O operations and you have dynamic I/O enabled in VM, then CP, once up, can start to add chpids, control units, and devices to the I/O config. Alan Altmark z/VM Development IBM Endicott
Re: IOCP for MP2003-204
Hi George, it sounds good. I will look into that.Do you happen to have a copy of the IOCP source for your MP2003-205 handy. It would be greatly appreciated if you can post it or send me a copy for reference. Thanks a lot in advance.Regards,...RolandGeorge Haddad [EMAIL PROTECTED] wrote: Our 2003-205 can be IMLed to do Dynamic I/O. We never did implement that feature --- we just never made many I/O changes over the yrs -- so I don't know if that negates the need for an inital IOCDS load or not.Jim Bohnsack wrote: It's been quite a while since I worked at that level but I didn't (don't) think that CP is going to be able to sense anything that isn't defined in the active IOCDS. It seems to me that was why I used to have to give a tape to the CE to load a basic IOCDS that would be enough to start with. I hope I'm wrong. Jim At 11:38 AM 6/15/2006, you wrote: --0-1955985212-1150385931=:22404 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi Peter, that is what I will do. Just talked to the hardware installer. No, he is not going to create a basic IOCP for us. But, he agreed to format the Shark for us to emulate 3390-3. He will also leave us a list on what CHPID the devices are connected to. I have managed to create a standalone IPLable tape with ICKDSF and DDR before they took down the Hitachi. I would format the needed DASDs and restore the CP OWNED volumns - 4 of them. Then I will try to IPL VM. At that stage, I can use all 6 tape drives to restore the other 60 DASDs. Hopefully, I can re-IPL to bring up the full VM system. Since CP would sense all the devices, I think I can use the DCPRDEVS utility to build a file of all real devices on the system. From there, I can build the final IOCS file and put it back to the service element using the IOCP command. Thanks for your suggestions. Regards, ...Roland
Re: IOCP for MP2003-204
Well, Rich, the Hitachi is out the door already. I hope the computer room manager would have a picture of the old machine configuration showing how the devices are connected to the Hitachi. With that, the installer can put a basic IOCP on the MP2003-204's storage element. As I know of on the Hitachi: DASD are on 200-23F Tapes are on 320 to 32F. Good luck to me! Regards, ...Roland --- Rich Smrcina [EMAIL PROTECTED] wrote: That is going to be next to impossible without knowing the CHPID numbers and device numbers that they need. It's time to reconnect the Hitachi box. Roland P. Chung wrote: Hello Listers, please help! I've been parachuted into the middle of this. *SIGH* The client is migrating from a Hitachi EX-22 to a MP2003-204. The operating system is VM/ESA 2.30. Before they took down the old system , we did not make a copy of the IOCP. The only thing we've managed to do is DDR copied all 64 3390-3 DASDs. Could anyone has an IOCP similiar to the MP2003 system that I can borrow. The new system's configuration is as follow: CPU 15 CEC/Cage Airflow cards (0012) 1 External HMC/SE(0015) 1 204 1-Way Processor(0603) 1 No Crypto Hardware (0808) 2 4 port parallel cards (2304) 2 ESCON Channel (2313) 1 FIBBAC Card(2338) 1 1024 MN Memory Card(3024) 1 Token Ring (5201) 1 Small Console Display (6090) 1 4.8M 3 Phase - US (8887) 1 Northern Hemisphere(9930) Plus devices from the old system IBM 3490 Tape Systems 3490E A10 Controller 3490E B40 w/4 Tape Transports w/Autoloaders 3490E B20 w/2 Tape Transports w/Autoloaders IBM 4245/12 Printer IBM 3174/1L Communications Controller (coax connections) IBM 3172/3 Communications Controller (Ethernet connections) DASD 4 36.4gb 8 paks (2123) 4 ESCON Channels 8 GB cache * to be configured as 3390-3 Thanks a lot in advance. With best regards, ...Roland Chung Senior Technical Specialist (S/390,VM/VSE,DB2/VSEVM) MAXC Consultants Inc. Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268) 197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6 ** Life is short. Stop once in a while and smell the roses. ** -- Rich Smrcina VM Assist, Inc. Main: (262)392-2026 Cell: (414)491-6001 Ans Service: (360)715-2467 rich.smrcina at vmassist.com Catch the WAVV! http://www.wavv.org WAVV 2007 - Green Bay, WI - May 18-22, 2007 With best regards, ...Roland Chung Senior Technical Specialist (S/390,VM/VSE,DB2/VSEVM) MAXC Consultants Inc. Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268) 197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6 ** Life is short. Stop once in a while and smell the roses. **
Re: IOCP for MP2003-204
Hi Peter, that is what I will do.Just talked to the hardware installer. No, he is not going to create a basic IOCP for us. But, he agreed to format the Shark for us to emulate 3390-3. He will also leaveus a list on what CHPID the devices are connected to.I have managed to create a standalone IPLable tape with ICKDSF and DDR before they took downthe Hitachi.I wouldformat the needed DASDs and restore the CP OWNED volumns -4 of them. Then I will try to IPL VM. At that stage, I can use all 6 tape drives to restore the other60DASDs. Hopefully, I can re-IPL to bring up the full VM system.Since CP would sense all the devices, I think I can use the DCPRDEVS utility to build a file of all real devices on the system. From there, I can build the final IOCS file and put it back to the service element using the IOCP command. Thanks for yoursuggestions. Regards,...Roland[EMAIL PROTECTED] wrote: Hi Roland,Well, if the 2003-204 is anything like our 2003-225, then you have somework to do. First, VM/ESA 2.3 should run just fine; we ran it forseveral years before upgrading to z/VM 3.1. You can forget the old IOCPfrom the Hitachi box, or any IOCP from another shop. The problem here is that the CHPID numbers on the 2003 start at x'40'and go up, with some skips (e.g. No x'4F'). Have your hardware guy cableup the equipment the way it makes most sense to him, and create a basicIOCP. I assume you are using the internal dasd. As per Rob van der Heij, haveyour hardware guy set them up as 3390-3. You will also get some smallvolumes in this configuration, watch out for them. They can be usefullater, but will be a pain right now. IPL standalone ICKDSF from your backup tapes and format all the volumes.Use standalone DDR to restore your backups. Try IPLing your systemresidence volume when you have finished the restores. If you are lucky,and the customer used sensible VM configuration options, you should getat least OPERATOR up, and maybe the whole system.Peter snipped With best regards,...Roland ChungSenior Technical Specialist (S/390,VM/VSE,DB2/VSEVM)MAXC Consultants Inc.Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268)197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6** Life is short. Stop once in a while and smell the roses. **
IOCP for MP2003-204
Hello Listers, please help! I've been parachuted into the middle of this. *SIGH* The client is migrating from a Hitachi EX-22 to a MP2003-204. The operating system is VM/ESA 2.30. Before they took down the old system , we did not make a copy of the IOCP. The only thing we've managed to do is DDR copied all 64 3390-3 DASDs. Could anyone has an IOCP similiar to the MP2003 system that I can borrow. The new system's configuration is as follow: CPU 15 CEC/Cage Airflow cards (0012) 1 External HMC/SE(0015) 1 204 1-Way Processor(0603) 1 No Crypto Hardware (0808) 2 4 port parallel cards (2304) 2 ESCON Channel (2313) 1 FIBBAC Card(2338) 1 1024 MN Memory Card(3024) 1 Token Ring (5201) 1 Small Console Display (6090) 1 4.8M 3 Phase - US (8887) 1 Northern Hemisphere(9930) Plus devices from the old system IBM 3490 Tape Systems 3490E A10 Controller 3490E B40 w/4 Tape Transports w/Autoloaders 3490E B20 w/2 Tape Transports w/Autoloaders IBM 4245/12 Printer IBM 3174/1L Communications Controller (coax connections) IBM 3172/3 Communications Controller (Ethernet connections) DASD 4 36.4gb 8 paks (2123) 4 ESCON Channels 8 GB cache * to be configured as 3390-3 Thanks a lot in advance. With best regards, ...Roland Chung Senior Technical Specialist (S/390,VM/VSE,DB2/VSEVM) MAXC Consultants Inc. Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268) 197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6 ** Life is short. Stop once in a while and smell the roses. **
Re: VM 5.2 GCS problem (I think)
Hi Stve, I GOOGLEd the message and found this: Date: Mon, 24 Sep 2001 18:01:26 -0400 Reply-To: VM/ESA Discussions [log in to unmask] Sender: VM/ESA Discussions [log in to unmask] From: Ferguson, Neale [log in to unmask] Subject: Re: VTAM or GCS Abend on VM/ESA V2R4? Content-Type: text/plain; charset=iso-8859-1 Isn't this a privileged operation exception. This means the virtual machine needs to be setup as a privileged member of the GCS group (pardon the terminology). -Original Message- I created directory entries for VTAM83 and RSCS83 as duplicates of VTAM and RSCS in the 2nd-level system. However, VTAM abends with the following message when I XAUTOLOG VTAM83. GCTABD230E Command 'EXEC' failed - System abend 0C2- I can't find this message in the System Messages and Codes for V2R2 or V2R4, nor in the GCS manual for V2R2 (I don't have a GCS manual for V2R4). @ http://listserv.uark.edu/scripts/wa.exe?A2=ind0109L=ibmvmT=0P=38056 It is old, but may shad some light. Another one: Date: Wed, 21 Sep 2005 14:01:08 -0400 Reply-To: VM/ESA and z/VM Discussions [log in to unmask] Sender: VM/ESA and z/VM Discussions [log in to unmask] From: Horlick, Michael [log in to unmask] Subject: Re: SNAPRSIM - Need help Content-Type: multipart/alternative; Thank you, Peter. BTW Thanks to all who responded. I issued the CONFIG AUTHUSER ADD SNAFU and it came up fine. Funny thing is that I have several userid's (RSCS , VTAM, TPX) IPLing GCS but nothing in my PROFILE GCS on userid's GCS 191 disk. Mike @ http://listserv.uark.edu/scripts/wa.exe?A2=ind0509L=ibmvmT=0P=39791 I hope this helps. ...Roland --- Steve Gentry [EMAIL PROTECTED] wrote: Hello. I'm getting the following messages PDLLIP01:233 *-* 'APRMTSK' PDLLIP01: APRMTSK PDLLIP01: GCTABD230E Command 'EXEC' failed - System abend 0C2- PDLLIP01: Ready; We RSCS and have printers attached via ethernet to our system Can anyone tell me where I can find some info on the abend code? I use HELP on VM for GCTABD230E and it says to Refer to the GCS Abend table in this publication . . What pub? There isn't one listed on the HELP screen. Thanks, Steve G. With best regards, ...Roland Chung Senior Technical Specialist (S/390,VM/VSE,DB2/VSEVM) MAXC Consultants Inc. Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268) 197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6 ** Life is short. Stop once in a while and smell the roses. **
Re: db2 7.4 and TCPIP on VM 5.2
Hi Steve, for that pesky DB2 problem, you may have to rebuilt and resave the CEEPIPI module. ^e^ You can review the Appendix E. IBM Language Environment for VM User Exit Customization for use with TCP/IP in the DB2/VM Program Directory on how to tailor the CEEBXITB before rebuld and resave the CEEPIPI module. I hope this help. ...Roland --- Steve Gentry [EMAIL PROTECTED] wrote: I will see if our DBA guy can post it. Thanks to both you guys for the reply. I didn't think I'd get anything this late in the night. One of us is spending to much time at work. 8-) Steve G. Roland P. Chung [EMAIL PROTECTED] Sent by: The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU 05/27/2006 10:51 PM Please respond to The IBM z/VM Operating System To: IBMVM@LISTSERV.UARK.EDU cc: Subject:Re: db2 7.4 and TCPIP on VM 5.2 Hi Steve, TCPPORT=0 means does not start TCP/Ip support. Can you post the error messages from the DB2/VM server? ... Roland --- Steve Gentry [EMAIL PROTECTED] wrote: Hello. Has anyone experienced a problem with the subject line working together? We're in the midst of an install this weekend and db2 won't come up when talking to/ working with tcpip. When we use port 0 on the tcpport parameter of the start command it comes up fine. Any ideas? Thanks, Steve G. With best regards, ...Roland Chung Senior Technical Specialist (S/390,VM/VSE,DB2/VSEVM) MAXC Consultants Inc. Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268) 197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6 ** Life is short. Stop once in a while and smell the roses. ** With best regards, ...Roland Chung Senior Technical Specialist (S/390,VM/VSE,DB2/VSEVM) MAXC Consultants Inc. Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268) 197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6 ** Life is short. Stop once in a while and smell the roses. **
Re: db2 7.4 and TCPIP on VM 5.2
Hi Steve, TCPPORT=0 means does not start TCP/Ip support. Can you post the error messages from the DB2/VM server? ... Roland --- Steve Gentry [EMAIL PROTECTED] wrote: Hello. Has anyone experienced a problem with the subject line working together? We're in the midst of an install this weekend and db2 won't come up when talking to/ working with tcpip. When we use port 0 on the tcpport parameter of the start command it comes up fine. Any ideas? Thanks, Steve G. With best regards, ...Roland Chung Senior Technical Specialist (S/390,VM/VSE,DB2/VSEVM) MAXC Consultants Inc. Voice/Fax: 416-469-3280 (If busy, call: 416-469-2268) 197 Hastings Ave., Toronto, Ontario, Canada. M4L 2L6 ** Life is short. Stop once in a while and smell the roses. **
