Received: from darkside. (darkside. [210.8.201.180]) by mail. (Weasel v1.20) for ; 09 Sep 2001 01:00:00 From: "Digest" To: "OS/2GenAu Digest" Date: Sun, 09 Sep 2001 01:00:00 +1000 (EDT) Priority: Normal X-Mailer: CASMailer 1.0 for OS/2 Warp PPC 1.05 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Subject: [os2genau_digest] No. 160 Message-ID: <200109090100.000029G6atmail.> Reply-To: Date:- 09 September 2001 Please reply to ianatos2site dot com to post to the list. A small problem with the list Digest Mode software replacing email address. 1================================================ From: "John Angelico" Date: Sat, 08 Sep 2001 00:29:38 +0800 (WST) Subject: [os2genau] Fwd: EMEAWarp Newsflash: Potential problem with DB2 UDB for OS/2 Versions 5, 6 and 7 : DB2 backups using userexits may fail For the information of all any DB2 users URGENT!!! Received from impeccable IBM sources Best regards John Angelico OS/2 SIG talldadatmelbpc dot org dot au or talldadatkepl dot com dot au ____________________________________________ ==================BEGIN FORWARDED MESSAGE================== Subject: EMEAWarp Newsflash: Potential problem with DB2 UDB for OS/2 Versions 5, 6 and 7 : DB2 backups using userexits may fail Importance: Urgent Dear All, IBM is notifying you of a potential problem with DB2 UDB for OS/2 Versions 5, 6 and 7 that may cause "DB2 backups using userexit" to fail on or after Sept 8/2001 or Sept 9/2001 based on the timezone the machine operates under. This may require your customer to either install a fix or to follow a workaround procedure to circumvent the problem. Please forward the attached note to your customers immediately as this problem will manifest itself on the date/time that may vary slighlty for different customers based on the machine timezone. Problem: On September 8/2001 or 9/2001 (i.e., 21:46:40 Sept 8 EST (Toronto time) or 01:46:40 Sept 9 GMT), the 32-bit time value gains a digit to go from 999999999 to 1000000000. The exact time of the failure will depend on which timezone the machine operates under. The result is that DB2 will not pass the fifth parameter, the MODE or sequence #, to the BACKUP USEREXIT. As a result of this as of this date/time Database Backups on OS/2 via a USEREXIT for a database alias of 8 characters will no longer work and as such a backup will not be taken. The error or message you see will be dependant on how you have coded your userexit; If you are using the default userexit, you will see an invalid parameter error being reported by the userexit. DB2 Products effected: This problem is only related to the OS/2 platform and does not affect other USEREXITs (eg. LOG) or Backups taken without USEREXITs. Customer Impact: Inability to perform DB2 UDB backups on OS/2 via a USEREXIT as of September 8/2001 or 9/2001 (i.e., 01:46:40 Sept 9 GMT, or 21:46:40 Sept 8 EST) Resolution: Apply DB2 UDB for OS/2 APAR JR16294 or use the suggested workaround. Fix Availability: Fix Status for releases currently in service: The fix for this problem has been uploaded to the DB2 UDB FIXPAK FTP site in the OS/2 directory for each release currently in service and we are developing a fix for V5 (out of service). The patched DLLs are stored in the archive file JR16294.zip. All NLV would use the same patch. A readme in the same directory (English only) is available to outline the problem/workaround/patch installation (JR16294.TXT). Location of FIX for V 6.1 FixPak 8: ftp://ftp.software.ibm dot com/ps/products/db2/fixes/english/db2os2v61/FP8 _WR21255/ Location of FIX for V 7.1 FixPak 3: ftp://ftp.software.ibm dot com/ps/products/db2/fixes/english/db2os2v7/FP3_ WR21251/ Note that this fix could only be applied to specified FIXPAK levels (FixPak 3 for V7.1 and FixPak 8 for V 6.1) and will not correct the problem for customers on special/private builds. They will either need to upgrade to one of these levels before applying the patch or will need to use the workaround until the next FixPak is made available. Fix Status for releases which are not in service (V5 only) but customers may have bought a service extension: Location of FIX for V 5.2 FixPak 16: A fix is being developed and will be uploaded to ftp://ftp.software.ibm dot com/ps/products/db2/fixes/english/db2os2v5/FP16 _WR21262/ location. The fix will be in a file called "db22v5_JR16294.zip" and a readme in the same directory (English only) will also be available to outline the problem/workaround/patch installation (JR16294.TXT). We are expecting to have this fix developed and uploaded by end of day Friday Toronto time. Note that this fix could only be applied to V5.2 FixPak level 16 and will not correct the problem for customers on special/private builds. They will need to use the workaround. TCO Customers can use one of the following options: - Upgrade to one of the above listed levels and apply the available patch for your Version/FixPak level. - Contact your local DB2 support organization and provide all the service/build level for your TCO to request a special fix. In the meantime, you may have to use the workaround to circumvent the problem until a fix can be made available for the requested TCO level. Workaround: Catalog another database alias to your database using 7 characters or less and use this database alias for performing your backups. You must ensure that the restores are performed using the same database alias as was used for the backup. By cataloging a separate alias, you avoid having to reconfigure all your remote database clients; making it transparent to your users. ===================END FORWARDED MESSAGE=================== 2============================================== Date: Fri, 07 Sep 2001 23:09:02 +0830 From: Leigh Bunting Subject: Re: [os2genau] Game Hidden in Star Office ! Ed Durrant wrote: > There is a game hidden in the Star Office spreadsheet. I stand corrected - it is there :-)) Doh! Leigh Bunting Colonel Light Gardens South Australia Find out more about Col. Light Gdns. here - http://www.chariot dot net dot au/~pknight/clghs/