Mike, It is more than just SMPE. You have to run the DB2 processes to complete the upgrade. I have not installed DB2 in a few years. But there are some customization clists you need to run which will work on your DB2 Catalogs and Tables. You can do the update so long as you script the process. I have not had any issues as a z/OS Sysprog doing DB2 Ugrades. But I have also been lucky enough to have some DB2 training. If you do not have any DB2 training, then it may make it more interesting.
Length of time will depend on the type of envionment (1 DB2 vs. 100 DB2 regions). You need to go to Compatibility mode from DB2 V7 to V8, then convert it to NFM (new function mode) as soon as possible. I would recommend you join the DB2 newsgroup How do I subscribe to DB2-L? You must be subscribed to DB2-L in order to post a message to the list. Your 'reply-to' email must exactly match the email that you are subscribed with when you post a message to DB2-L. Method 1 – Web interface: Go to this link: Listserve Archives DB2-L. Click on 'Join or leave the list (or change settings)'. Log into the web interface if desired (to avoid email confirmations - see FAQ for web interface). Enter your email address and your name. You can also pick your settings when you subscribe. The default setting is for a regular subscription (you receive each email as they are posted to the list). Change any of the options if desired and click the 'Join DB2-L' button. Method 2 – Command: Address an email to [EMAIL PROTECTED], subject is blank, include this text in the body of the email: SUBSCRIBE DB2-L. You will receive a confirmation email that you need to reply to. Lizette > >My current client needs an upgrade from DB2 v7 to DB2 v8, and soon. Having not >done one before, I am not sure if it's just another SMP/E install with all the >attendant PARMLIB, PROCLIB, PPT, etc. updates that can be handled following a >documented installation process or if it's something that needs a DB2 expert >to accomplish. We have DBA expertise here to answer any application- or >database-related questions, so that may suffice as on-site DB2 expertise. > >So the question is: Is this something that a z/OS system programmer should be >able to accomplish >with DBA assistance, or do we need to get a DB2 system >programmer to do the job? Additionally, >how long should such an update take? ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
