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
|