473,325 Members | 2,774 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

DB2 patches - need historical record of proof

Hello,
I am relatively new to DB2 LUW (v9.1).
I have been asked to prove the history of patches to the database. I know I
didn't apply any (we started on fix pack #1), and that we are testing fix
pack #4, but how do I prove this? Is there a hidden (or not hidden) file
somewhere in the DB2 install directories that keeps track of my patch history
for me since my auditors won't take me at my word.
thanks much,
Norma Jean

--
Message posted via http://www.dbmonster.com

Jul 7 '08 #1
9 2919
normajeansebastian via DBMonster.com wrote:
Hello,
I am relatively new to DB2 LUW (v9.1).
I have been asked to prove the history of patches to the database. I know I
didn't apply any (we started on fix pack #1), and that we are testing fix
pack #4, but how do I prove this? Is there a hidden (or not hidden) file
somewhere in the DB2 install directories that keeps track of my patch history
for me since my auditors won't take me at my word.
thanks much,
Norma Jean
Can you show us output of this command?

db2 select * from sysibm.sysversions
Jan Nelken
Jul 7 '08 #2
Lew
It's not exactly what you are looking for but db2grep -dump might be
useful
Jul 7 '08 #3
Hi Jan,
my output from db2 "select * from sysibm.sysversions" is:

VERSIONNUMBER VERSION_TIMESTAMP AUTHID
------------- -------------------------- --------------
9010100 2007-10-19-14.38.09.918476 DB2PRD

are you saying that if i had more fix packs, such as fix pack 4, i would see
2 output lines?
that would be cool. (10/19/07 is when we went live on v9.1 fp1)

thanks!

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200807/1

Jul 7 '08 #4
Hi Lew,
I ran "db2grep -dump" as instance owner and i got "command not found".
is that only valid on certain platforms? (i am on solaris 10, sorry if i did
not post system info originally).
thanks.

Lew wrote:
>It's not exactly what you are looking for but db2grep -dump might be
useful
--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200807/1

Jul 7 '08 #5
Hi Jan,
this is lovely!
i ran it on one of our test systems and it did indeed return another row for
the FP4 we are testing:

9010100 2007-10-19-14.38.09.918476 DB2PRD
9010400 2008-06-02-11.12.13.876158 DB2SP2

Thanks!!
Norma Jean

normajeansebastian wrote:
>Hi Jan,
my output from db2 "select * from sysibm.sysversions" is:

VERSIONNUMBER VERSION_TIMESTAMP AUTHID
------------- -------------------------- --------------
9010100 2007-10-19-14.38.09.918476 DB2PRD

are you saying that if i had more fix packs, such as fix pack 4, i would see
2 output lines?
that would be cool. (10/19/07 is when we went live on v9.1 fp1)

thanks!
--
Message posted via http://www.dbmonster.com

Jul 7 '08 #6
normajeansebastian via DBMonster.com wrote:
i ran it on one of our test systems and it did indeed return another row for
the FP4 we are testing:

9010100 2007-10-19-14.38.09.918476 DB2PRD
9010400 2008-06-02-11.12.13.876158 DB2SP2

You may also notice that DB2PRD is the "install userid" (account from
which the install was performed); while DB2SP2 is the accout which
applied fix pack.
Jan M. Nelken
Jul 7 '08 #7
On Jul 7, 8:01*pm, "normajeansebastian via DBMonster.com" <u5287@uwe>
wrote:
Hello,
I am relatively new to DB2 LUW (v9.1).
I have been asked to prove the history of patches to the database. *I know I
didn't apply any (we started on fix pack #1), and that we are testing fix
pack #4, but how do I prove this? * Is there a hidden (or not hidden) file
somewhere in the DB2 install directories that keeps track of my patch history
for me since my auditors won't take me at my word.
thanks much,
Norma Jean

--
Message posted viahttp://www.dbmonster.com
Use 'db2level' as described here:
http://publib.boulder.ibm.com/infoce...c/r0009195.htm

HTH

--
Jeroen
Jul 7 '08 #8
Ian
normajeansebastian via DBMonster.com wrote:
Hi Lew,
I ran "db2grep -dump" as instance owner and i got "command not found".
is that only valid on certain platforms? (i am on solaris 10, sorry if i did
not post system info originally).
thanks.

Lew wrote:
>It's not exactly what you are looking for but db2grep -dump might be
useful
The command is 'db2greg' -- typo in Lew's suggestion.

I think sysibm.sysversions is better, though.

Jul 8 '08 #9
the command is:
db2greg -dump
and gives you all software including fixpacks you've installed on the
system.
version 8 and 9 - all together.
Jul 8 '08 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Josh Mayfield | last post by:
Note: There is considerable background detail here, but I do have three questions, which are clearly marked and appear right before the sample code. I have a legitimate need to launch an EXE...
1
by: rottytooth | last post by:
A general data design question: We have data which changes every week. We had considered seperating historical records and current records into two different tables with the same columns, but...
3
by: Erwin | last post by:
I have a work assignment in which I have to put a historical archive within access which can be used for trendlines etc. It contains data about month, service percentages and numbers. Within a...
8
by: Ben Fidge | last post by:
Hi I'm working on a site which requires the users to specify a hotel at which they're staying in London. The complete list of hotels comes to something like 1600 records. Each record consists of...
5
by: campbellbrian2001 | last post by:
I'm trying to get the "Carry data over to new record" code to work from Allen Browne's site: http://allenbrowne.com/ser-24.html I follwed the instruction explicitly and somethings not working......
4
by: georges the man | last post by:
hey guys, i ve been posting for the last week trying to understand some stuff about c and reading but unfortunaly i couldnt do this. i have to write the following code. this will be the last...
0
by: U S Contractors Offering Service A Non-profit | last post by:
Brilliant technology helping those most in need Inbox Reply U S Contractors Offering Service A Non-profit show details 10:37 pm (1 hour ago) Brilliant technology helping those most in need ...
9
by: Susan Bricker | last post by:
Greetings. My disclaimer first - I am a neophyte where VB and ACCESS are concerned, but I have been programming for quite a long time. That said ... I created a db at work using MS/ACCESS 2000...
0
by: HydroPnik | last post by:
Hi all! What a great community you have here. Being an Access newbie I have already used much information gleaned from the other posters for my current project. I have been tasked with creating a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.