[Maybe Spam] [DB2-L] DB2 Connect - db2syscs.exe & db2diag.log

Raymond Bell

[Maybe Spam] [DB2-L] DB2 Connect - db2syscs.exe & db2diag.log
Hi Natalie,

1) Dunno. I'm a mainframer too - mostly - but also dabble in the black art
that is UDB on Windows. Unfortunately I'm not au fait (I'm doing French
evening classes on a Tuesday - does it show?) enough with the various
services to know what that one is, let alone why it might nail your server.

2) As someone else suggested, you can just delete the file. We've got a bit
of housekeeping REXX that runs at midnight, renaming the db2diag.log file to
be something like db2diag_ccyymmdd.log and deleting the existing
db2diag.log. DB2 will create a new one the next time it feels the need to
write to it. We also purge diag log files older than a week, I think. Easy
to do when they're date-stamped.

So, 1 from 2. Is that a pass?

Cheers,


Raymond Bell
Database Administrator


-----Original Message-----
From: DB2 Data Base Discussion List on behalf of Natalie Faulkner
Sent: Fri 1/19/2007 9:40 PM
To: [login to unmask email]
Subject: [Maybe Spam] [DB2-L] DB2 Connect - db2syscs.exe & db2diag.log

I'm an old mainframer who has recently inherited our DB2 Connect Server
and Software so please speak s-l-o-w-l-y !!!!

I have 2 questions...

1) db2syscs.exe pegged our DB2 Connect box this morning and only allowed
minimal traffic to go through to the enterprise server... I have looked
through db2diag.log and couldn't find anything abnormal. Any ideas on
where I could find further log information or what may have caused this ???

2) While researching problem 1, I found that the db2diag.log contained
several years of log records and has grown quite large... Any
recommendations on what is the best way to purge/compress this file ???

Thanks in Advance !!!

Natalie Faulkner
State of WV - IS&C Data Center

----------------------------------------------------------------------------
-----
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 [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm



This e-mail (and any attachments) may contain privileged and/or confidential information. If you are not the intended recipient please do not disclose, copy, distribute, disseminate or take any action in reliance on it. If you have received this message in error please reply and tell us and then delete it. Should you wish to communicate with us by e-mail we cannot guarantee the security of any data outside our own computer systems. For the protection of Legal & General's systems and staff, incoming emails will be automatically scanned.

Any information contained in this message may be subject to applicable terms and conditions and must not be construed as giving investment advice within or outside the United Kingdom.

The following companies are subsidiary companies of the Legal & General Group Plc which are authorised and regulated by the Financial Services Authority for advising and arranging the products shown: Legal & General Partnership Services Limited (insurance and mortgages), Legal & General Insurance Limited (insurance), Legal & General Assurance Society Limited
(life assurance, pensions and investments), Legal & General Unit Trust Managers Limited and Legal & General Portfolio Management Services Limited (investments).

They are registered in England under numbers shown.
The registered office is Temple Court, 11 Queen Victoria Street, London EC4N 4TP.

Legal & General Partnership Services Limited: 5045000 Legal & General Assurance Society Limited: 166055 Legal & General (Unit Trust Managers) Limited: 1009418 Legal & General (Portfolio Management Services) Limited: 2457525 Legal & General Insurance Limited: 423930

They are registered with the Financial Services Authority under numbers shown. You can check this at www.fsa.gov.uk/register

Legal & General Partnership Services Limited: 300792 Legal & General Assurance Society Limited: 117659 Legal & General (Unit Trust Managers) Limited: 119273 Legal & General (Portfolio Management Services) Limited: 146786 Legal & General Insurance Limited: 202050


---------------------------------------------------------------------------------
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 [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Walter Trovijo Jr (UOL)

Re: DB2 Connect - db2syscs.exe & db2diag.log
(in response to Raymond Bell)
Natalie,

Is it a wintel box? If so, your second question partially answers the first one. Windows is the only software that burns; yes, like a bulb. It works for some time - even several years in some cases -
but one day it will burn, you have to reinstall it. I've had this problem 3 times over last 7 years with our DB2 Connect servers, and we only have half-dozen servers like this; from time to time you
have to install everything from scratch. Other suspects are hw problems, like a malfunctioning hdd, it does not generate any messages until you start loosing your data.

HTH,
Walter Trovijo Jr.


---------------------------------------------------------------------------------
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 [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Philip Sevetson

Re: DB2 Connect - db2syscs.exe & db2diag.log
(in response to Walter Trovijo Jr (UOL))
Have you tried the classic "Reboot the Box" strategy yet, and did it help at
all?

--Phil


On 1/19/07, Natalie Faulkner <[login to unmask email]> wrote:
>
> I'm an old mainframer who has recently inherited our DB2 Connect Server
> and Software so please speak s-l-o-w-l-y !!!!
>
> I have 2 questions...
>
> 1) db2syscs.exe pegged our DB2 Connect box this morning and only allowed
> minimal traffic to go through to the enterprise server... I have looked
> through db2diag.log and couldn't find anything abnormal. Any ideas on
> where I could find further log information or what may have caused this
> ???
>
> 2) While researching problem 1, I found that the db2diag.log contained
> several years of log records and has grown quite large... Any
> recommendations on what is the best way to purge/compress this file ???
>
> Thanks in Advance !!!
>
> Natalie Faulkner
> State of WV - IS&C Data Center
>
>
> ---------------------------------------------------------------------------------
> 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
> [login to unmask email] Find out the latest on IDUG conferences
> at http://conferences.idug.org/index.cfm
>



--
--Phil Sevetson
IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for
OS/390
IBM Certified Database Administrator -- DB2 Universal Database V8.1 for zOS
The Reserve
New York, NY, USA
ANY OPINIONS OR RECOMMENDATIONS EXPRESSED IN THIS EMAIL
ARE MY OWN, NOT MY EMPLOYER'S OR IBM'S.

---------------------------------------------------------------------------------
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 [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm