Attention DB2/VM users

[Roland P. Chung]

Hi all, Please be adviced that you shouold do more frequent archive of your DB2/VM database if you are using dataspace support and is running under z/VM 5.20.

I will provide more information on this subject later.


*** cross post to VSE-L ***


With best regards,

...Roland Chung
Senior Technical Specialist (S/390,VM/VSE,DB2/VSE&VM)
MAXC Consultants Inc.
Voice/Fax: [phone] (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. **

[Alan Ackerman]

I don't know if this is related, but we just got bit with DB2 server hard down. We installed z/VM
5.2.0 on a 2084 this weekend and DB2 came up OK at 6am Sunday and ran until 11pm. A batch
job at that point crashed and took down the DB2 server. The directory, we think, was corrupted.
Fortunately, we had a backup from Sunday so we were able to get the server back up, but we
aren't running that batch job. The job was tested OK on a second level guest of the same VM
system, running z/VM 5.2.0 under z/VM 5.1.0.

DB2 support seem to think it is a problem with data spaces. VM support says we have all the latest
PTFs, but there is a piece of microcode for the 2084 that we don't have.

Post by Roland P. Chung
Hi all, Please be adviced that you shouold do more frequent archive of your DB2/VM database if

you are using dataspace support and is running under z/VM 5.20.

Post by Roland P. Chung
I will provide more information on this subject later.
*** cross post to VSE-L ***
With best regards,
...Roland Chung
Senior Technical Specialist (S/390,VM/VSE,DB2/VSE&VM)
MAXC Consultants Inc.
Voice/Fax: [phone] (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. **

[Roland P. Chung]

Hi Ed, it does not matter what release of DB2/VM. It is the dataspaces support in z/VM 5.20 seems to cause this problem. I know of, DB2/VSE&VM Support is working closely with VM development trying to identify/resolve this problem. They are advising user to temporary take the DB2/VM database off from dataspaces support. Yes, it is a toss up between performance and database corruption! *SIGH*

I hope this help.

Regards,

...Roland

Post by Alan Ackerman

Post by Roland P. Chung
Hi all, Please be adviced that you shouold do more frequent
archive of your DB2/VM database if you are using dataspace
support and is running under z/VM 5.20.

I don't know if this is related, but we just got bit with DB2 server
hard down. We installed z/VM 5.2.0 on a 2084 this weekend and DB2
came up OK at 6am Sunday and ran until 11pm.

I was curious what version of DB2 for VM this was, or does
that even matter if the problem is with VM dataspaces?

This reminds me of a MAP MDISK problem with VM/ESA 1.2 that we
ran into back in 1993 on SQL/DS 3.3.0. We had to turn off
dataspace support for several months until it was resolved.
Not a pleasant experience at all.

Ed Zell
[phone] x-107
***@illinoismutual.com

.


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/VSE&VM)
MAXC Consultants Inc.
Voice/Fax: [phone] (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. **