DB2 for z/OS V8 - LOAD utility question

Jim McAlpine

DB2 for z/OS V8 - LOAD utility question
(in response to Jim McAlpine)
I'm getting the following when running LOAD and I've RTFM and I can't find
much info on it -

DSNU1173I * 348 17:18:02.06 DSNURWI - TABLE SPACE Z30DDA01.SAACNTRL WILL BE
CONVERTING FROM BASIC ROW FORMAT TO REORDERED ROW FORMAT

Can someone explain exactly what it is telling me. What specific tablespace
attribute is being changed if any ?

Jim McAlpine

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

Jim McAlpine

DB2 for z/OS V8 - LOAD utility question
Sorry, that subject should have said DB2 V9. No wonder I couldn't find
anything, I was looking at the wrong manuals.

Jim McAlpine

On Tue, Dec 14, 2010 at 4:30 PM, Jim McAlpine <[login to unmask email]>wrote:

> I'm getting the following when running LOAD and I've RTFM and I can't find
> much info on it -
>
> DSNU1173I * 348 17:18:02.06 DSNURWI - TABLE SPACE Z30DDA01.SAACNTRL WILL BE
> CONVERTING FROM BASIC ROW FORMAT TO REORDERED ROW FORMAT
>
> Can someone explain exactly what it is telling me. What specific
> tablespace attribute is being changed if any ?
>
> Jim McAlpine
>

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

Steen Rasmussen

Re: DB2 for z/OS V8 - LOAD utility question
(in response to Jim McAlpine)
Jim - from DB2 V8, for tables having VARCHAR columns, DB2 will optimize
the management of these tables by physically move all VARCHAR columns to
the end and then have a set of OFFSET's in front of these guys. This
will happen at LOAD REPLACE / REORG time, and if you don't want to
utilize this feature, there is a ZPARM parameter to control it. You can
identify which partitions/tablespaces having RRF/BRF by looking at
SYSTABLEPART.format.



Please be aware of DSN1COPY too.



Steen Rasmussen
CA Technologies
Sr Engineering Services Architect

IBM Certified Database Associate - DB2 9 Fundamentals

IBM Certified database Administrator - DB2 9 DBA for z/OS
Tel: +1-630-505-6673
Mobile: +1-708-382-1363
[login to unmask email]
<mailto:[login to unmask email]> < http://www.ca.com/ >



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jim McAlpine
Sent: Tuesday, December 14, 2010 10:30 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 for z/OS V8 - LOAD utility question



I'm getting the following when running LOAD and I've RTFM and I can't
find much info on it -



DSNU1173I * 348 17:18:02.06 DSNURWI - TABLE SPACE Z30DDA01.SAACNTRL WILL
BE CONVERTING FROM BASIC ROW FORMAT TO REORDERED ROW FORMAT



Can someone explain exactly what it is telling me. What specific
tablespace attribute is being changed if any ?



Jim McAlpine



________________________________

Independent, not-for-profit, User Run - the IDUG difference!
< http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.
< http://www.idug.org/register >


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

Chris Tee

Re: DB2 for z/OS V8 - LOAD utility question
(in response to Steen Rasmussen)

Steen

RRF first appeared in V9 NFM, has it been retrofitted to V8?

Chris



Date: Wed, 15 Dec 2010 01:40:30 -0500
From: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS V8 - LOAD utility question
To: [login to unmask email]








Jim – from DB2 V8, for tables having VARCHAR columns, DB2 will optimize the management of these tables by physically move all VARCHAR columns to the end and then have a set of OFFSET’s in front of these guys. This will happen at LOAD REPLACE / REORG time, and if you don’t want to utilize this feature, there is a ZPARM parameter to control it. You can identify which partitions/tablespaces having RRF/BRF by looking at SYSTABLEPART.format.

Please be aware of DSN1COPY too.

Steen Rasmussen
CA Technologies
Sr Engineering Services Architect
IBM Certified Database Associate - DB2 9 Fundamentals
IBM Certified database Administrator - DB2 9 DBA for z/OS
Tel: +1-630-505-6673
Mobile: +1-708-382-1363
[login to unmask email]



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jim McAlpine
Sent: Tuesday, December 14, 2010 10:30 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 for z/OS V8 - LOAD utility question


I'm getting the following when running LOAD and I've RTFM and I can't find much info on it -



DSNU1173I * 348 17:18:02.06 DSNURWI - TABLE SPACE Z30DDA01.SAACNTRL WILL BE CONVERTING FROM BASIC ROW FORMAT TO REORDERED ROW FORMAT



Can someone explain exactly what it is telling me. What specific tablespace attribute is being changed if any ?



Jim McAlpine





The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.




The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.
_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

Steen Rasmussen

Re: DB2 for z/OS V8 - LOAD utility question
(in response to Chris Tee)
Sorry - you're absolutely right, and I also noticed Jim sent a
correction that he was on a DB2 9 environment.



Steen Rasmussen
CA Technologies
Sr Engineering Services Architect

IBM Certified Database Associate - DB2 9 Fundamentals

IBM Certified database Administrator - DB2 9 DBA for z/OS



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Chris Tee
Sent: Wednesday, December 15, 2010 3:51 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS V8 - LOAD utility question



Steen

RRF first appeared in V9 NFM, has it been retrofitted to V8?

Chris


________________________________

Date: Wed, 15 Dec 2010 01:40:30 -0500
From: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS V8 - LOAD utility question
To: [login to unmask email]

Jim - from DB2 V8, for tables having VARCHAR columns, DB2 will optimize
the management of these tables by physically move all VARCHAR columns to
the end and then have a set of OFFSET's in front of these guys. This
will happen at LOAD REPLACE / REORG time, and if you don't want to
utilize this feature, there is a ZPARM parameter to control it. You can
identify which partitions/tablespaces having RRF/BRF by looking at
SYSTABLEPART.format.



Please be aware of DSN1COPY too.



Steen Rasmussen
CA Technologies
Sr Engineering Services Architect

IBM Certified Database Associate - DB2 9 Fundamentals

IBM Certified database Administrator - DB2 9 DBA for z/OS
Tel: +1-630-505-6673
Mobile: +1-708-382-1363
[login to unmask email]
<mailto:[login to unmask email]> < http://www.ca.com/ >



From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jim McAlpine
Sent: Tuesday, December 14, 2010 10:30 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 for z/OS V8 - LOAD utility question



I'm getting the following when running LOAD and I've RTFM and I can't
find much info on it -



DSNU1173I * 348 17:18:02.06 DSNURWI - TABLE SPACE Z30DDA01.SAACNTRL WILL
BE CONVERTING FROM BASIC ROW FORMAT TO REORDERED ROW FORMAT



Can someone explain exactly what it is telling me. What specific
tablespace attribute is being changed if any ?



Jim McAlpine



________________________________

Independent, not-for-profit, User Run - the IDUG difference!
< http://www.idug.org/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.
< http://www.idug.org/register >



________________________________

Independent, not-for-profit, User Run - the IDUG difference!
< http://www.idug.org/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.
< http://www.idug.org/register >



________________________________

Independent, not-for-profit, User Run - the IDUG difference!
< http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.
< http://www.idug.org/register >


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

Satish Srikakulapu

Re: DB2 for z/OS V8 - LOAD utility question
(in response to Steen Rasmussen)
Steen,

This brings up a question, that might have been answered but I wanted to know. What is the ZPARM to control this behavior, and can we reconvert tablespaces that are in RRF as of now to BRF back?

Thanks,
Satish Srikakulapu


From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Rasmussen, Steen
Sent: Tuesday, December 14, 2010 11:40 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS V8 - LOAD utility question

Jim - from DB2 V8, for tables having VARCHAR columns, DB2 will optimize the management of these tables by physically move all VARCHAR columns to the end and then have a set of OFFSET's in front of these guys. This will happen at LOAD REPLACE / REORG time, and if you don't want to utilize this feature, there is a ZPARM parameter to control it. You can identify which partitions/tablespaces having RRF/BRF by looking at SYSTABLEPART.format.

Please be aware of DSN1COPY too.

Steen Rasmussen
CA Technologies
Sr Engineering Services Architect
IBM Certified Database Associate - DB2 9 Fundamentals
IBM Certified database Administrator - DB2 9 DBA for z/OS
Tel: +1-630-505-6673
Mobile: +1-708-382-1363
[login to unmask email]
<mailto:[login to unmask email]>[file:///C:\Program%20Files\CA\GIS\CASig\CA_email.gif ] < http://www.ca.com/ >

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jim McAlpine
Sent: Tuesday, December 14, 2010 10:30 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 for z/OS V8 - LOAD utility question

I'm getting the following when running LOAD and I've RTFM and I can't find much info on it -

DSNU1173I * 348 17:18:02.06 DSNURWI - TABLE SPACE Z30DDA01.SAACNTRL WILL BE CONVERTING FROM BASIC ROW FORMAT TO REORDERED ROW FORMAT

Can someone explain exactly what it is telling me. What specific tablespace attribute is being changed if any ?

Jim McAlpine

________________________________

[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

________________________________

[ http://www.idug.org/images/banners/idug_2011.gif ] < http://www.idug.org >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

Email Firewall made the following annotations

---------------------------------------------------------------------
--- NOTICE ---

This message is for the designated recipient only and may contain confidential, privileged or proprietary information. If you have received it in error, please notify the sender immediately and delete the original and any copy or printout. Unintended recipients are prohibited from making any other use of this e-mail. Although we have taken reasonable precautions to ensure no viruses are present in this e-mail, we accept no liability for any loss or damage arising from the use of this e-mail or attachments, or for any delay or errors or omissions in the contents which result from e-mail transmission.

---------------------------------------------------------------------


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

Myron Miller

Re: DB2 for z/OS V8 - LOAD utility question
(in response to Satish Srikakulapu)
Why would you want to convert back? For varchar column tables, this will
eventually prove to be more efficient access to these tables. Not a lot, but
some, so why degrade potentially efficiency improvements?

Myron



________________________________
From: Satish Srikakulapu <[login to unmask email]>
To: [login to unmask email]
Sent: Wed, December 15, 2010 10:28:46 AM
Subject: Re: [DB2-L] DB2 for z/OS V8 - LOAD utility question


Steen,

This brings up a question, that might have been answered but I wanted to know.
What is the ZPARM to control this behavior, and can we reconvert tablespaces
that are in RRF as of now to BRF back?

Thanks,
Satish Srikakulapu


From:IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Rasmussen, Steen
Sent: Tuesday, December 14, 2010 11:40 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 for z/OS V8 - LOAD utility question

Jim – from DB2 V8, for tables having VARCHAR columns, DB2 will optimize the
management of these tables by physically move all VARCHAR columns to the end and
then have a set of OFFSET’s in front of these guys. This will happen at LOAD
REPLACE / REORG time, and if you don’t want to utilize this feature, there is a
ZPARM parameter to control it. You can identify which partitions/tablespaces
having RRF/BRF by looking at SYSTABLEPART.format.

Please be aware of DSN1COPY too.

Steen Rasmussen
CA Technologies
Sr Engineering Services Architect
IBM Certified Database Associate - DB2 9 Fundamentals
IBM Certified database Administrator - DB2 9 DBA for z/OS
Tel: +1-630-505-6673
Mobile: +1-708-382-1363
[login to unmask email]


From:IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Jim McAlpine
Sent: Tuesday, December 14, 2010 10:30 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 for z/OS V8 - LOAD utility question

I'm getting the following when running LOAD and I've RTFM and I can't find much
info on it -

DSNU1173I * 348 17:18:02.06 DSNURWI - TABLE SPACE Z30DDA01.SAACNTRL WILL BE
CONVERTING FROM BASIC ROW FORMAT TO REORDERED ROW FORMAT

Can someone explain exactly what it is telling me. What specific tablespace
attribute is being changed if any ?

Jim McAlpine


________________________________

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not
already an IDUG member, please register here.



________________________________

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not
already an IDUG member, please register here.

Email Firewall made the following annotations
---------------------------------------------------------------------
--- NOTICE ---
This message is for the designated recipient only and may contain confidential,
privileged or proprietary information. If you have received it in error, please
notify the sender immediately and delete the original and any copy or printout.
Unintended recipients are prohibited from making any other use of this e-mail.
Although we have taken reasonable precautions to ensure no viruses are present
in this e-mail, we accept no liability for any loss or damage arising from the
use of this e-mail or attachments, or for any delay or errors or omissions in
the contents which result from e-mail transmission.

---------------------------------------------------------------------

________________________________

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not
already an IDUG member, please register here.


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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