> -----Original Message----- > From: IBM Mainframe Discussion List > [mailto:[EMAIL PROTECTED] On Behalf Of Yan Ying > Sent: Monday, April 16, 2007 8:58 AM > To: [email protected] > Subject: Collect DB2 message log SMF > > > Hi all, > We want to collect DB2 LOG from DB2 MSTR ADDRESS SPACE from > the prod system.The address space can be shutdown,so we cannot use > IBM external writer.I know we can use SDSF batch mode to print > Address Space to dataset.I want to know if there are certain SMF > record type contain the DB2 message?And how to print it to dataset? > Another question is if we can find whole DB2 LOG in SYSLOG or OPERLOG? > Thanks for your concern. > > BR > YY
I am not familiar with the "DB2 LOG". Is it a SYSOUT type dataset? I gather so since you say that you can see it with SDSF. You can, usually, direct SYSOUT to the MVS SYSLOG by "cheating" a bit. Suppose you have a JCL statement similar to: //DB2LOG DD SYSOUT=A You can replace that with the following to direct it to the MVS SYSLOG (or OPERLOG, whichever you are using) //DB2LOG DD PATH='/dev/console', // FILEDATA=TEXT, // RECFM=???,LRECL=???, // PATHOPTS=(OWRONLY) Note you must replace the question marks with the appropriate values for your application. Now, this will prefix all the records being written to DB2LOG with a message prefix of BPXF024I when they are actually written to SYSLOG. If you have an automated operations package, you can suppress this message from going to the actual OS operator consoles, while still allowing it to go to the SYSLOG/OPERLOG. Note that the messages will be interspersed with all the other messages on the SYSLOG, so finding them may be "fun". I am not aware of any easy way to write SYSOUT data to SMF. As a system programmer, I would resist this because our SMF data is huge anyway. I do know that DB2 can write some type of records to SMF, but I don't know what is contained it them or if they would help you. Have you asked on the DB2 list? [EMAIL PROTECTED] <quote> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [EMAIL PROTECTED] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm </quote> -- John McKown Senior Systems Programmer HealthMarkets Keeping the Promise of Affordable Coverage Administrative Services Group Information Technology The information contained in this e-mail message may be privileged and/or confidential. It is for intended addressee(s) only. If you are not the intended recipient, you are hereby notified that any disclosure, reproduction, distribution or other use of this communication is strictly prohibited and could, in certain circumstances, be a criminal offense. If you have received this e-mail in error, please notify the sender by reply and delete this message without copying or disclosing it. ---------------------------------------------------------------------- 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
