nv-l
[Top] [All Lists]

Re: NetView for Unix Y2k issue

To: nv-l@lists.tivoli.com
Subject: Re: NetView for Unix Y2k issue
From: Duane Waddle <waddle1@US.IBM.COM>
Date: Fri, 7 Jan 2000 13:26:18 -0600
If you are loading data using the ARCHIVE=YES in the
/usr/OV/conf/snmpColfiles, then the flat files will get blown away after
the 1900 data is loaded into the RDBMS.    I was, however, able to salvage
mine by using the (ugly) DB2/6000 SQL attached below.  I apologize for how
nasty it is in advance, but it did fix my data.

-------------------------------------------(snip)------------------------------------------
connect to netview

update db2inst1.coldata set collecttime=
timestamp(cast(year(collecttime)+100 AS CHAR(4))               \
                        CONCAT SUBSTR(cast(cast(month(collecttime) AS
DECIMAL(2)) AS CHAR(3)),1,2)      \
                        CONCAT SUBSTR(cast(cast(day(collecttime) AS
DECIMAL(2)) AS CHAR(3)),1,2)        \
                        CONCAT SUBSTR(cast(cast(hour(collecttime) AS
DECIMAL(2)) AS CHAR(3)),1,2)       \
                        CONCAT SUBSTR(cast(cast(minute(collecttime) AS
DECIMAL(2)) AS CHAR(3)),1,2)     \
                        CONCAT SUBSTR(cast(cast(second(collecttime) AS
DECIMAL(2)) AS CHAR(3)),1,2)     \
                )






       where
            \
                year(collecttime)=1900

--------------------------------------------(snip)-------------------------------------------

--D

Duane Waddle
waddle1@us.ibm.com
"With sufficient thrust, pigs fly just fine..."  -- RFC1925


Mark_Stowers@TIVOLI.COM@UCSBVM.UCSB.EDU> on 01/07/2000 11:44:11 AM

Please respond to Discussion of IBM NetView and POLYCENTER Manager on
      NetView <NV-L@UCSBVM.UCSB.EDU>

Sent by:  Discussion of IBM NetView and POLYCENTER Manager on NetView
      <NV-L@UCSBVM.UCSB.EDU>


To:   NV-L@UCSBVM.UCSB.EDU
cc:
Subject:  NetView for Unix Y2k issue



I know that this is not new news, but wanted to provide information on a
Y2k
issue found with NetView for Unix.

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.

Mark Stowers
Manager, NetView for UNIX/NT Level 3 Support
mstowers@tivoli.com


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

Archive operated by Skills 1st Ltd

See also: The NetView Web