Versioning am I missing Something?

Jorg Lueke

Versioning am I missing Something?
In looking at the Admin Guide and SQL Reference it appears that the
oldest_version column in systablespace/systablepart can be reset by running
a reorg and a modify removing all the image copies in the old version. This
does not appear to happen, at least not in all cases. So I took an object
and ran Reorg. Then a modfy removing all image copies, followed by a fresh
full copy. Still, I see the odlest_version listed at 0 instead of 2? How
can this be?

Here's some info from the catalog

DBNAME NAME OLDEST_VERSION CURRENT_VERSIO
---------+---------+---------+---------+---------+---------+--
CSOD02I0 CSOS0202 0 2

DBNAME TSNAME PARTITION OLDEST_VERSION REORG_LR_TS
---------+---------+---------+---------+---------+---------+---------+--
CSOD02I0 CSOS0202 1 0 2010-01-14-10
CSOD02I0 CSOS0202 2 0 2010-01-14-10
CSOD02I0 CSOS0202 3 0 2010-01-14-10
CSOD02I0 CSOS0202 4 0 2010-01-14-10
CSOD02I0 CSOS0202 5 0 2010-01-14-10
CSOD02I0 CSOS0202 6 0 2010-01-14-10
CSOD02I0 CSOS0202 7 0 2010-01-14-10
CSOD02I0 CSOS0202 8 0 2010-01-14-10
CSOD02I0 CSOS0202 9 0 2010-01-14-10
CSOD02I0 CSOS0202 10 0 2010-01-14-10
CSOD02I0 CSOS0202 11 0 2010-01-14-10
CSOD02I0 CSOS0202 12 0 2010-01-14-10
CSOD02I0 CSOS0202 13 0 2010-01-14-10
CSOD02I0 CSOS0202 14 0 2010-01-14-10
CSOD02I0 CSOS0202 15 0 2010-01-14-10

DBNAME TSNAME ICTYPE ICDATE OLDEST_VERSION
---------+---------+---------+---------+---------+
CSOD02I0 CSOS0202 M 100114 -1
CSOD02I0 CSOS0202 M 100114 -1
CSOD02I0 CSOS0202 M 100114 -1
CSOD02I0 CSOS0202 S 100114 2
CSOD02I0 CSOS0202 W 100114 2
CSOD02I0 CSOS0202 F 100114 2

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-content/index.html has THOUSANDS of free technical presentations!
DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI, Warehouses, - among
many more categories of help waiting for you!
Whether you are an old hand or a DB2 newbie, we have presentations for every level.
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Jorg Lueke

Re: Versioning am I missing Something?
(in response to Jorg Lueke)
This looks like a bug, we have the previous maintenance that addresses
versioning issues. Now we have to fight through level 1 support. Charge!

On Thu, 14 Jan 2010 16:38:19 +0000, Jorg Lueke <[login to unmask email]> wrote:

>In looking at the Admin Guide and SQL Reference it appears that the
>oldest_version column in systablespace/systablepart can be reset by running
>a reorg and a modify removing all the image copies in the old version. This
>does not appear to happen, at least not in all cases. So I took an object
>and ran Reorg. Then a modfy removing all image copies, followed by a fresh
>full copy. Still, I see the odlest_version listed at 0 instead of 2? How
>can this be?
>
>Here's some info from the catalog
>
>DBNAME NAME OLDEST_VERSION CURRENT_VERSIO
>---------+---------+---------+---------+---------+---------+--
>CSOD02I0 CSOS0202 0 2
>
>DBNAME TSNAME PARTITION OLDEST_VERSION REORG_LR_TS
>---------+---------+---------+---------+---------+---------+---------+--
>CSOD02I0 CSOS0202 1 0 2010-01-14-10
>CSOD02I0 CSOS0202 2 0 2010-01-14-10
>CSOD02I0 CSOS0202 3 0 2010-01-14-10
>CSOD02I0 CSOS0202 4 0 2010-01-14-10
>CSOD02I0 CSOS0202 5 0 2010-01-14-10
>CSOD02I0 CSOS0202 6 0 2010-01-14-10
>CSOD02I0 CSOS0202 7 0 2010-01-14-10
>CSOD02I0 CSOS0202 8 0 2010-01-14-10
>CSOD02I0 CSOS0202 9 0 2010-01-14-10
>CSOD02I0 CSOS0202 10 0 2010-01-14-10
>CSOD02I0 CSOS0202 11 0 2010-01-14-10
>CSOD02I0 CSOS0202 12 0 2010-01-14-10
>CSOD02I0 CSOS0202 13 0 2010-01-14-10
>CSOD02I0 CSOS0202 14 0 2010-01-14-10
>CSOD02I0 CSOS0202 15 0 2010-01-14-10
>
>DBNAME TSNAME ICTYPE ICDATE OLDEST_VERSION
>---------+---------+---------+---------+---------+
>CSOD02I0 CSOS0202 M 100114 -1
>CSOD02I0 CSOS0202 M 100114 -1
>CSOD02I0 CSOS0202 M 100114 -1
>CSOD02I0 CSOS0202 S 100114 2
>CSOD02I0 CSOS0202 W 100114 2
>CSOD02I0 CSOS0202 F 100114 2
>
>_____________________________________________________________________
>
>* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
>_____________________________________________________________________
>
>http://www.idug.org/db2-content/index.html has THOUSANDS of free technical
presentations!
>DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI,
Warehouses, - among
>many more categories of help waiting for you!
>Whether you are an old hand or a DB2 newbie, we have presentations for
every level.
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Kathy Culp

Re: Versioning am I missing Something?
(in response to Jorg Lueke)
You may need to run REPAIR VERSIONS TABLESPACE dbname.tsname to get the
versions back in sync.

Kathy Culp
Database Administration
972.766.3410
8.766.3410 or 63410(internal)




Jorg Lueke <[login to unmask email]>
Sent by: IDUG DB2-L <[login to unmask email]>
01/15/2010 11:15 AM
Please respond to
IDUG DB2-L <[login to unmask email]>


To
[login to unmask email]
cc

Subject
Re: [DB2-L] Versioning am I missing Something?






This looks like a bug, we have the previous maintenance that addresses
versioning issues. Now we have to fight through level 1 support. Charge!

On Thu, 14 Jan 2010 16:38:19 +0000, Jorg Lueke <[login to unmask email]>
wrote:

>In looking at the Admin Guide and SQL Reference it appears that the
>oldest_version column in systablespace/systablepart can be reset by
running
>a reorg and a modify removing all the image copies in the old version.
This
>does not appear to happen, at least not in all cases. So I took an
object
>and ran Reorg. Then a modfy removing all image copies, followed by a
fresh
>full copy. Still, I see the odlest_version listed at 0 instead of 2? How
>can this be?
>
>Here's some info from the catalog
>
>DBNAME NAME OLDEST_VERSION CURRENT_VERSIO
>---------+---------+---------+---------+---------+---------+--
>CSOD02I0 CSOS0202 0 2
>
>DBNAME TSNAME PARTITION OLDEST_VERSION REORG_LR_TS
>---------+---------+---------+---------+---------+---------+---------+--
>CSOD02I0 CSOS0202 1 0 2010-01-14-10
>CSOD02I0 CSOS0202 2 0 2010-01-14-10
>CSOD02I0 CSOS0202 3 0 2010-01-14-10
>CSOD02I0 CSOS0202 4 0 2010-01-14-10
>CSOD02I0 CSOS0202 5 0 2010-01-14-10
>CSOD02I0 CSOS0202 6 0 2010-01-14-10
>CSOD02I0 CSOS0202 7 0 2010-01-14-10
>CSOD02I0 CSOS0202 8 0 2010-01-14-10
>CSOD02I0 CSOS0202 9 0 2010-01-14-10
>CSOD02I0 CSOS0202 10 0 2010-01-14-10
>CSOD02I0 CSOS0202 11 0 2010-01-14-10
>CSOD02I0 CSOS0202 12 0 2010-01-14-10
>CSOD02I0 CSOS0202 13 0 2010-01-14-10
>CSOD02I0 CSOS0202 14 0 2010-01-14-10
>CSOD02I0 CSOS0202 15 0 2010-01-14-10
>
>DBNAME TSNAME ICTYPE ICDATE OLDEST_VERSION
>---------+---------+---------+---------+---------+
>CSOD02I0 CSOS0202 M 100114 -1
>CSOD02I0 CSOS0202 M 100114 -1
>CSOD02I0 CSOS0202 M 100114 -1
>CSOD02I0 CSOS0202 S 100114 2
>CSOD02I0 CSOS0202 W 100114 2
>CSOD02I0 CSOS0202 F 100114 2
>
>_____________________________________________________________________
>
>* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
>_____________________________________________________________________
>
>http://www.idug.org/db2-content/index.html has THOUSANDS of free
technical
presentations!
>DB2 LUW, DB2 z/OS, Performance, Installation, Tuning, Coding, BI,
Warehouses, - among
>many more categories of help waiting for you!
>Whether you are an old hand or a DB2 newbie, we have presentations for
every level.
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is
the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions
Journal
Technical atricles from world famous authors in DB2's most prestigious,
peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's DB2-L



HCSC Company Disclaimer

The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of
the addressee. Unauthorized use, disclosure, distribution or copying is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify the sender immediately at (312)
653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in
Oklahoma; or (972)766-6900 in Texas.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Shery hepp

Re: Versioning am I missing Something?
(in response to Kathy Culp)
You don't mention what version of db2 you're running- but I recall an issue we had here with some tablespaces created a long time ago- having a version error when they were trying to refresh the data from production to test. They use dsn1copy which had issues with the version number. We got around it by running loads- or by dropping and recreating the tablespace. Since it was test it wasn't an issue. Maybe this will help you- do you don't have to go through IBM support and pay. Hope this helps.

Regards, Shery

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jorg Lueke
Sent: Friday, January 15, 2010 9:39 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Versioning am I missing Something?

This looks like a bug, we have the previous maintenance that addresses
versioning issues. Now we have to fight through level 1 support. Charge!

Jorg Lueke

Re: Versioning am I missing Something?
(in response to Shery hepp)
No, these are DB2 9, created in May of last year and altered twice since
then. These are totally new so there should be no need to run Repair
Versions. I'll update the list when the ETR is closed.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/events/index.html is your DB2 Events calendar! RUG meetings,
Webcasts, Conferences- what is going on next?
RUG leaders- get your events on the calendar today!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L