nv-l

Re: nvColToSQL Y2K Problem

2000-09-15 13:39:20
Subject: Re: nvColToSQL Y2K Problem
From: Leonid.Golstein AT gecits-eu DOT com
To: nv-l AT lists.tivoli DOT com
Date: Fri, 15 Sep 2000 18:39:20 +0100
Hello Dave,

fyi



lclark AT us.ibm DOT com on 24.08.2000 15:45:32

Please respond to IBM NetView Discussion <nv-l AT tkg DOT com>

To:     IBM NetView Discussion <nv-l AT tkg DOT com>
cc:      (bcc: Leonid Golstein/Kerpen/GECITS-EU)
Subject:  Re: [NV-L] Millenium Bug in colData
                                                                                
                                                                                
 ------------------------------------------------------------------------------ 






This is apar IY07219. The fix is shipped with 6.01, and has also been
available as
an efix from support since the first of the year.

Notes from the original posting of the problem:

Flash for NetView Y2k issue documented in APAR IY07219.

Users affected:  Any NetView for Unix user that uses nvColToSQL to convert
SNMP
flat file data into a
SQL database or any user of NetView Tivoli Decision Support Guides. This is
not
a service down situation.

Resolution:  An efix has been coded for IY07219 and is available by
contacting
Tivoli service.

IMPORTANT: This fix repairs the conversion process to ensure data integrity
for
snmpCollect data
transferred AFTER installation of the fix.  Data converted after the year
change
and before the installation
of this fix must be deleted from the relational database using the
nvColTable -C
command and reconverted
from the existing flat files in /usr/OV/databases/snmpCollect.  These files
are
not deleted when converted
to the relational database so they are still available to be converted
correctly, using the repaired
nvColToSQL command.
==      ==           ==        ==         ==


Cordially,

Leslie A. Clark
IBM Global Services - Systems Mgmt & Networking
Detroit


Leonid.Golstein AT gecits-eu DOT [email protected] on 08/24/2000 11:06:03 AM

Please respond to IBM NetView Discussion <nv-l AT tkg DOT com>

Sent by:  owner-nv-l AT tkg DOT com


To:   IBM NetView Discussion <nv-l AT tkg DOT com>
cc:   "DE_NSM"@gecits-eu.com
Subject:  [NV-L] Millenium Bug in colData





Hallo all,

My NetView-System is NetView 6.0, SPARC Solaris 7, Oracle 7.3.4,
Oracle-RIM.

I copy my snmpCollect-Data with the Program nvColToSQL to the Oracle-DB.

I make the following query:
select collectTime from ColData where collectTime Between ... and ...

In the field collectTime (table collData) I see 1900  (instead from 2000)
!!!

Can I fix this bug with any patch  ?



Gruesse - Best regards

Leonid Golstein
GE Capital IT Solutions / GE CompuNet Computer AG
European Information Management, Europe
Europaring 34-40, 50170 Kerpen, Germany
Phone: +49 (0) 2273 / 597-259, Fax: +49 (0) 2273 / 597-570, Mobile: +49 (0)
172
/ 8421230
E-Mail : Leonid.Golstein @ gecits-eu.com
http://www.gecits-eu.com


This email is confidential. If you are not the intended recipient,
you must not disclose or use the information contained in it.
If you have received this mail in error, please tell us
immediately by return email and delete the document.


_________________________________________________________________________
NV-L List information and Archives: http://www.tkg.com/nv-l



_________________________________________________________________________
NV-L List information and Archives: http://www.tkg.com/nv-l



Gruesse - Best regards

Leonid Golstein
GE Capital IT Solutions / GE CompuNet Computer AG
European Information Management, Europe
Europaring 34-40, 50170 Kerpen, Germany
Phone: +49 (0) 2273 / 597-259, Fax: +49 (0) 2273 / 597-570, Mobile: +49 (0) 172
/ 8421230
E-Mail : Leonid.Golstein @ gecits-eu.com
http://www.gecits-eu.com


This email is confidential. If you are not the intended recipient,
you must not disclose or use the information contained in it.
If you have received this mail in error, please tell us
immediately by return email and delete the document.





Dave_Finn AT computacenter DOT com on 15.09.2000 15:26:49

Please respond to IBM NetView Discussion <nv-l AT tkg DOT com>

To:     nv-l AT tkg DOT com
cc:      (bcc: Leonid Golstein/Kerpen/GECITS-EU)
Subject:  [NV-L] nvColToSQL Y2K Problem
                                                                                
                                                                                
 ------------------------------------------------------------------------------ 






Hi,

I am running Netview for Unix 6.0 on AIX 4.3.  I am trying to set up the
relational database on a Sybase 11.5 Server, which is running on the same
machine.

I had the nvColToSQL program running so the data was getting into the database,
but it was showing 1900 as the year.

So I installed the patch (6.0-NVD-IY07219) from the tivoli ftp site, which is
supposed to fix the Y2K problem.

Now when I run nvColToSQL I get :-

#./nvColToSQL
exec(): 0509-036 Cannot load program ./nvColToSQL because of the following
errors:
        0509-150   Dependent module libtmf.a(shr.o) could not be loaded.
        0509-022 Cannot load module libtmf.a(shr.o).
        0509-026 System error: A file or directory in the path name does not
exist.
#

Has anyone else seen this problem, and if so how did they fix it.

Cheers

Dave




**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************
_________________________________________________________________________
NV-L List information and Archives: http://www.tkg.com/nv-l


<Prev in Thread] Current Thread [Next in Thread>