data compression

[login to unmask email]

data compression
HI all

How can you determine if DB2 data is using hardware compression and/or
software
compression.

Tom

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Alice Frus

Re: data compression
(in response to Missy Case)
I had the same question - I had to ask the DASD guys about the hardware
part and take their word for it.
Your tablespace ddl should show you compress=yes - I think default is no.



"Tom Taylor"
<[login to unmask email] To:
[login to unmask email]
M> cc:
Sent by: "DB2 Subject: data compression
Data Base
Discussion List"
<[login to unmask email]
ORG>
01/16/2004 03:13
PM
Please respond to
"DB2 Database
Discussion list
at IDUG"




HI all

How can you determine if DB2 data is using hardware compression and/or
software
compression.

Tom

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

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org
. The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm





**********
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;
(972)766-6900 in Texas; or (800)835-8699 in New Mexico.
**********

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Missy Case

Re: data compression
(in response to ttaylor@CHUBB.COM)
Tom,
An editproc would be software compression. You need to drop & recreate
reload to get rid of them. Hardware compression should be the only one
that gives you a 'Y' off the tablepart catalog table Compress column.
Editproc is at the table level, column name EDPROC


Missy Case
FDR
701-275-6358




Tom Taylor
<[login to unmask email] To: [login to unmask email]
M> cc:
Sent by: DB2 Data bcc:
Base Discussion Subject: data compression
List
<[login to unmask email]
ORG>


01/16/04 03:13 PM
Please respond to
DB2 Database
Discussion list
at IDUG






HI all

How can you determine if DB2 data is using hardware compression and/or
software
compression.

Tom

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

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org
. The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Robert Lawrence

Re: data compression
(in response to Alice Frus)
Tom,
This is something I got from the list several years ago to determine if hardware or
software compression was available on our CPU.

/* rexx */
cvt = storage(10,4)
cmpflag = x2b(c2x(storage(d2x(c2d(cvt) + x2d(0179)),1)))
cvtcmpsc = translate(substr(cmpflag,1,1),'YN','10')
cvtcmpsh = translate(substr(cmpflag,2,1),'YN','10')
say 'software compression supported <' cvtcmpsc '>'
say 'hardware compression supported <' cvtcmpsh '>'
return



HTH
Bob Lawrence
DBA
Boscov's Dept Stores LLc



> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> Behalf Of Tom Taylor
> Sent: Friday, January 16, 2004 4:14 PM
> To: [login to unmask email]
> Subject: data compression
>
>
> HI all
>
> How can you determine if DB2 data is using hardware compression and/or
> software
> compression.
>
> Tom
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
> "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
> The IDUG List Admins can be reached at [login to unmask email] Find
> out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Philip Sevetson

Re: data compression
(in response to Robert Lawrence)
Excuse me, but I believe that is incomplete.

Some years ago, I worked for a company which had a small IBM mainframe,
and hardware compression was unavailable. I don't know whether such
machines are still used, but if someone is using one, then COMPRESS YES in
the tablespace/partition definition would only serve to invoke a DB2
compression routine which was not hardware-supported.

With that caveat, I agree that CREATEing or ALTERing a
tablespace/partition with COMPRESS YES normally causes DB2 to invoke
hardware-assisted compression in the next REORG or LOAD/REPLACE (for DB2
native compression to be used, a data dictionary must be built; that only
happens during a REORG or a LOAD/REPLACE).

--Phil Sevetson
Database Administration
Wakefern Food Corporation CISD
mailto:[login to unmask email]






[login to unmask email]
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/16/2004 04:28 PM
Please respond to DB2 Database Discussion list at IDUG


To: [login to unmask email]
cc:
Subject: Re: [DB2-L] data compression


Tom,
An editproc would be software compression. You need to drop & recreate
reload to get rid of them. Hardware compression should be the only one
that gives you a 'Y' off the tablepart catalog table Compress column.
Editproc is at the table level, column name EDPROC


Missy Case
FDR
701-275-6358

Tom Taylor
<[login to unmask email] To: [login to unmask email]
M> cc:
Sent by: DB2 Data bcc:
Base Discussion Subject: data compression
List
<[login to unmask email]
ORG>

HI all

How can you determine if DB2 data is using hardware compression and/or
software
compression.

Tom


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Missy Case

Re: data compression
(in response to Philip Sevetson)
Phil,
I should have broken my answer up into 2 parts.
editprocs:
The editproc you need to drop/recreate/reload to get rid of them....

Hardware Compression:
Compress Yes should also be used in conjunction with the pages saved to see
if it meets your criteria. It will build a better data dictionary with a
reorg than with a load, but either will work.
Missy Case
FDR
701-275-6358




[login to unmask email]
EFERN.COM To: [login to unmask email]
Sent by: DB2 Data cc:
Base Discussion bcc:
List Subject: Re: data compression
<[login to unmask email]
ORG>


01/16/04 03:46 PM
Please respond to
DB2 Database
Discussion list
at IDUG







Excuse me, but I believe that is incomplete.

Some years ago, I worked for a company which had a small IBM mainframe, and
hardware compression was unavailable. I don't know whether such machines
are still used, but if someone is using one, then COMPRESS YES in the
tablespace/partition definition would only serve to invoke a DB2
compression routine which was not hardware-supported.

With that caveat, I agree that CREATEing or ALTERing a tablespace/partition
with COMPRESS YES normally causes DB2 to invoke hardware-assisted
compression in the next REORG or LOAD/REPLACE (for DB2 native compression
to be used, a data dictionary must be built; that only happens during a
REORG or a LOAD/REPLACE).

--Phil Sevetson
Database Administration
Wakefern Food Corporation CISD
mailto:[login to unmask email]




[login to unmask email]
Sent by: DB2 Data Base Discussion List To:
<[login to unmask email]> [login to unmask email]
cc:
Subject: Re:
01/16/2004 04:28 PM [DB2-L] data compression
Please respond to DB2 Database Discussion
list at IDUG






Tom,
An editproc would be software compression. You need to drop & recreate
reload to get rid of them. Hardware compression should be the only one
that gives you a 'Y' off the tablepart catalog table Compress column.
Editproc is at the table level, column name EDPROC


Missy Case
FDR
701-275-6358

Tom Taylor
<[login to unmask email] To:
[login to unmask email]
M> cc:
Sent by: DB2 Data bcc:
Base Discussion Subject: data compression
List
<[login to unmask email]
ORG>

HI all

How can you determine if DB2 data is using hardware compression and/or
software
compression.

Tom

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

[login to unmask email]

Re: data compression
(in response to Missy Case)
Robert

That gave me exactly what I needed... thanks

Tom



Robert Lawrence
<[login to unmask email] To: [login to unmask email]
S.COM> cc:
Sent by: DB2 Data Subject: Re: [DB2-L] data compression
Base Discussion
List
<[login to unmask email]
ORG>


01/16/04 04:34 PM
Please respond to
rlawrence






Tom,
This is something I got from the list several years ago to determine if
hardware or
software compression was available on our CPU.

/* rexx */
cvt = storage(10,4)
cmpflag = x2b(c2x(storage(d2x(c2d(cvt) + x2d(0179)),1)))
cvtcmpsc = translate(substr(cmpflag,1,1),'YN','10')
cvtcmpsh = translate(substr(cmpflag,2,1),'YN','10')
say 'software compression supported <' cvtcmpsc '>'
say 'hardware compression supported <' cvtcmpsh '>'
return



HTH
Bob Lawrence
DBA
Boscov's Dept Stores LLc



> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> Behalf Of Tom Taylor
> Sent: Friday, January 16, 2004 4:14 PM
> To: [login to unmask email]
> Subject: data compression
>
>
> HI all
>
> How can you determine if DB2 data is using hardware compression and/or
> software
> compression.
>
> Tom
>
>
---------------------------------------------------------------------------------

> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select
> "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org.
> The IDUG List Admins can be reached at [login to unmask email]
Find
> out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm
>

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

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org
. The IDUG List Admins can be reached at [login to unmask email]
Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Robert Lawrence

Re: data compression
(in response to ttaylor@CHUBB.COM)
You are welcome

Bob Lawrence
DBA
Boscov's Dept Stores LLc



> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> Behalf Of Tom Taylor
> Sent: Friday, January 16, 2004 5:29 PM
> To: [login to unmask email]
> Subject: Re: data compression
>
>
> Robert
>
> That gave me exactly what I needed... thanks
>
> Tom
>
>
>
> Robert Lawrence
> <[login to unmask email] To: [login to unmask email]
> S.COM> cc:
> Sent by: DB2 Data Subject: Re: [DB2-L] data compression
> Base Discussion
> List
> <[login to unmask email]
> ORG>
>
>
> 01/16/04 04:34 PM
> Please respond to
> rlawrence
>
>
>
>
>
>
> Tom,
> This is something I got from the list several years ago to determine if
> hardware or
> software compression was available on our CPU.
>
> /* rexx */
> cvt = storage(10,4)
> cmpflag = x2b(c2x(storage(d2x(c2d(cvt) + x2d(0179)),1)))
> cvtcmpsc = translate(substr(cmpflag,1,1),'YN','10')
> cvtcmpsh = translate(substr(cmpflag,2,1),'YN','10')
> say 'software compression supported <' cvtcmpsc '>'
> say 'hardware compression supported <' cvtcmpsh '>'
> return
>
>
>
> HTH
> Bob Lawrence
> DBA
> Boscov's Dept Stores LLc
>
>
>
> > -----Original Message-----
> > From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
> > Behalf Of Tom Taylor
> > Sent: Friday, January 16, 2004 4:14 PM
> > To: [login to unmask email]
> > Subject: data compression
> >
> >
> > HI all
> >
> > How can you determine if DB2 data is using hardware compression and/or
> > software
> > compression.
> >
> > Tom
> >
> >
> ---------------------------------------------------------------------------------
>
> > Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
> home
> > page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
> select
> > "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org.
> > The IDUG List Admins can be reached at [login to unmask email]
> Find
> > out the latest on IDUG conferences at
> http://conferences.idug.org/index.cfm
> >
>
> ---------------------------------------------------------------------------------
>
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
> "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org
> . The IDUG List Admins can be reached at [login to unmask email]
> Find out the latest on IDUG conferences at
> http://conferences.idug.org/index.cfm
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
> "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
> The IDUG List Admins can be reached at [login to unmask email] Find
> out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm