REXX Freeware aka open source

cliff boley

REXX Freeware aka open source
I put a REXX together to help me with managing my DB2 3390 DASD.
I'm willing to share.
If you would like a copy send me an email.
I'll send a copy to Phil when he get the list documents up and running.
Below is an output sample.

No salesman will call and it won't add inches...
cliff:-)


>> Choose one of the following formats;
>> 1. file allocation in blocks to clys/trks (B #blocks blocksize)
>> 2. cylinders to DB2 DDL PRIQTY (C cylinders)
>> 3. DB2 DDL PRIQTY to DASD 3390 clys/trks (P priqty)
>> 4. Number of pages to DASD 3390 clys/trks (G # pages, # = 4,8,16,32)
>> 5. List allocation for a table (T db2 dbname.table)
>> 6. List allocation for an index (I db2 ixcreator.ixname)
>> 7. List all indexes on a given table (IQ db2 dbname.table)

C 5OO

>> DASD cylinder to DB2 PRIQTY conversion for cylinders = 500
DDL PRIQTY (in K) = 360000
cyls in Meg = 351.56
cyls in Gig = 0.34
PRIQTY for 4K pages = 90000 8k = 45000
16k pages = 22500 32k = 11250
percent of 3390-3 = 14.97




---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Dean Capps

Re: REXX Freeware aka open source
(in response to cliff boley)
REXX Freeware aka open sourceI would like a copy please.

Thanks,

Dean Capps,
MCI,
Enterprise Production Services (EPS) - DB2 DBA
[login to unmask email]
Vnet 622-6773
Contact (and other) information for the EPS DBA team can be found at:
http://psweb.mcilink.com/Environments/DB2/DB2home.htm

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
[login to unmask email]
Sent: Friday, December 12, 2003 4:18 PM
To: [login to unmask email]
Subject: REXX Freeware aka open source


I put a REXX together to help me with managing my DB2 3390 DASD.
I'm willing to share.
If you would like a copy send me an email.
I'll send a copy to Phil when he get the list documents up and running.
Below is an output sample.

No salesman will call and it won't add inches...
cliff:-)



>> Choose one of the following formats;
>> 1. file allocation in blocks to clys/trks (B #blocks blocksize)
>> 2. cylinders to DB2 DDL PRIQTY (C cylinders)
>> 3. DB2 DDL PRIQTY to DASD 3390 clys/trks (P priqty)
>> 4. Number of pages to DASD 3390 clys/trks (G # pages, # = 4,8,16,32)
>> 5. List allocation for a table (T db2 dbname.table)
>> 6. List allocation for an index (I db2 ixcreator.ixname)
>> 7. List all indexes on a given table (IQ db2 dbname.table)

C 5OO

>> DASD cylinder to DB2 PRIQTY conversion for cylinders = 500
DDL PRIQTY (in K) = 360000
cyls in Meg = 351.56
cyls in Gig = 0.34
PRIQTY for 4K pages = 90000 8k = 45000
16k pages = 22500 32k = 11250
percent of 3390-3 = 14.97



--------------------------------------------------------------------------------
- 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". If you will be out of the office, send the SET DB2-L
NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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