DB2 z/OS V10 DEFINE NO

Mike Johnson

DB2 z/OS V10 DEFINE NO

My client has a very large 1920 partition table space that I created using DEFINE NO to conserve DASD space.  The problem is when I initially load the first partition it appears DB2 attempts to define all partitions datasets - not just the few I am loading.

Is there a way to prevent DB2 from allocating un-used datasets? 

Thanks,

Mike J.

Philip Sevetson

DB2 z/OS V10 DEFINE NO
(in response to Mike Johnson)
**please note my email address change**
Did you try “INTO TABLE table-name PART n”?

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Mike Johnson [mailto:[login to unmask email]
Sent: Friday, July 21, 2017 12:51 PM
To: [login to unmask email]
Subject: [DB2-L] - DB2 z/OS V10 DEFINE NO


My client has a very large 1920 partition table space that I created using DEFINE NO to conserve DASD space. The problem is when I initially load the first partition it appears DB2 attempts to define all partitions datasets - not just the few I am loading.

Is there a way to prevent DB2 from allocating un-used datasets?

Thanks,

Mike J.

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)

Mike Johnson

RE: DB2 z/OS V10 DEFINE NO
(in response to Philip Sevetson)

Philip,

Below is the load control card I initially used. 

I have tried various combinations of options as shown below the load cards - all blow out around the 85th partition (I am only loading the first 20 partitions).

 

LOAD DATA INDDN SYRC0001 LOG NO          

 EBCDIC  CCSID(00285,00000,00000)        

 INTO TABLE                              

 "PDBCSM".                               

 "T431A_DLOSS_DETAIL_OLD"                

 PART 0001 RESUME NO REPLACE       

 WHEN(00001:00002) = X'002A'             

 NUMRECS              5791392            

 

 

LOAD DATA INDDN SYRC0001 LOG NO ...

      PART 0001 RESUME NO REPLACE REUSE

 

 LOAD DATA INDDN SYRC0001 LOG NO REUSE ...

      PART 1 RESUME NO

 

 LOAD DATA INDDN SYRC0001 LOG NO REUSE ...

      PART 1 RESUME NO REPLACE

 

 LOAD DATA INDDN SYRC0001 LOG NO ...

      PART 1 PREFORMAT RESUME NO REPLACE

 

This is a partition by range tablespace.

Regards,

Mike J.

Bruce Williamson

RE: DB2 z/OS V10 DEFINE NO
(in response to Mike Johnson)

If you aren't already, try using sliding scale allocation for tablespace partitions and indexes e.g.:

PRIQTY -1
SECQTY -1

Cheers
Bruce

 

P.S. Want to make a difference but don't know how? Join the RFE Community (Requests For Enhancement), no time like the present!!!

P.P.S. While you're at it why not join the "All DB2 for z/OS" group and find

Raymond Bell

DB2 z/OS V10 DEFINE NO
(in response to Philip Sevetson)
Working as designed, I’m afraid. Nowhere is it recorded if a dataset physically exists (from memory). Either way, once one part is instantiated, they all are.

RFE time I’m afraid.

Cheers,


Raymond

Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 21 July 2017 18:02
To: '[login to unmask email]'
Subject: [DB2-L] - RE: DB2 z/OS V10 DEFINE NO


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

**please note my email address change**
Did you try “INTO TABLE table-name PART n”?

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Mike Johnson [mailto:[login to unmask email]
Sent: Friday, July 21, 2017 12:51 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - DB2 z/OS V10 DEFINE NO


My client has a very large 1920 partition table space that I created using DEFINE NO to conserve DASD space. The problem is when I initially load the first partition it appears DB2 attempts to define all partitions datasets - not just the few I am loading.

Is there a way to prevent DB2 from allocating un-used datasets?

Thanks,

Mike J.

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (“RBS” or “us”) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you give your consent to the monitoring of your e-mail communications with us.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.

Visit our website at www.rbs.com http://www.rbs.com
Attachments

  • image001.png (3.3k)

Chris Tee

DB2 z/OS V10 DEFINE NO
(in response to Raymond Bell)
-1 in the SPACE column of SYSTABLEPART indicates that DEFINE NO was used and data is yet to be inserted. The manual also indicates that physical creation of the datasets takes place when data is first inserted into one of the partitions.

Get Outlook for iOS https://aka.ms/o0ukef
_____________________________
From: Bell, Raymond (IT Operations, Technology) <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Saturday, July 22, 2017 02:39
Subject: [DB2-L] - RE: DB2 z/OS V10 DEFINE NO
To: '[login to unmask email]<mailto:[login to unmask email]>' <[login to unmask email]<mailto:[login to unmask email]>>


Working as designed, I’m afraid. Nowhere is it recorded if a dataset physically exists (from memory). Either way, once one part is instantiated, they all are.

RFE time I’m afraid.

Cheers,


Raymond

Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS

From: Sevetson, Phil [ Sevetson, Phil [mailto:[login to unmask email]
Sent: 21 July 2017 18:02
To: '[login to unmask email]<mailto:[login to unmask email]>'
Subject: [DB2-L] - RE: DB2 z/OS V10 DEFINE NO


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

**please note my email address change**
Did you try “INTO TABLE table-name PART n”?

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Mike Johnson [mailto:[login to unmask email]
Sent: Friday, July 21, 2017 12:51 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - DB2 z/OS V10 DEFINE NO


My client has a very large 1920 partition table space that I created using DEFINE NO to conserve DASD space. The problem is when I initially load the first partition it appears DB2 attempts to define all partitions datasets - not just the few I am loading.

Is there a way to prevent DB2 from allocating un-used datasets?

Thanks,

Mike J.

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (“RBS” or “us”) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you give your consent to the monitoring of your e-mail communications with us.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.


Visit our website atwww.rbs.com http://www.rbs.com
-----End Original Message-----


Philip Sevetson

DB2 z/OS V10 DEFINE NO
(in response to Raymond Bell)
**please note my email address change**
How… counterintuitive. Thanks for the info, Raymond.

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Friday, July 21, 2017 9:39 PM
To: '[login to unmask email]'
Subject: [DB2-L] - RE: DB2 z/OS V10 DEFINE NO

Working as designed, I’m afraid. Nowhere is it recorded if a dataset physically exists (from memory). Either way, once one part is instantiated, they all are.

RFE time I’m afraid.

Cheers,


Raymond

Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 21 July 2017 18:02
To: '[login to unmask email]'
Subject: [DB2-L] - RE: DB2 z/OS V10 DEFINE NO


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************
**please note my email address change**
Did you try “INTO TABLE table-name PART n”?

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Mike Johnson [mailto:[login to unmask email]
Sent: Friday, July 21, 2017 12:51 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - DB2 z/OS V10 DEFINE NO


My client has a very large 1920 partition table space that I created using DEFINE NO to conserve DASD space. The problem is when I initially load the first partition it appears DB2 attempts to define all partitions datasets - not just the few I am loading.

Is there a way to prevent DB2 from allocating un-used datasets?

Thanks,

Mike J.

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (“RBS” or “us”) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you give your consent to the monitoring of your e-mail communications with us.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.


Visit our website at www.rbs.com http://www.rbs.com
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)

Raymond Bell

DB2 z/OS V10 DEFINE NO
(in response to Philip Sevetson)
Good, innit? At a previous site we thought it would be a good idea to define huge partitioned TSs, one per month, for a reasonable future – about 10 years from memory, maybe further. Imagine our disappointment when 1700 partitions suddenly materialised on 1st part load. Not what we wanted.

No doubt it’s working as designed. Equally no doubt the design needs a tweak.

And Chris is right; it does tell you whether the TS was created DEFINE NO – but that information isn’t recorded at the part level and, once the thing has been instantiated, there’s no way of knowing that’s how it was originally created. So currently I don’t think there’s a way for DB2 to know which, if any, parts have been physically created – other than trying to find the cluster, which doesn’t help if it’s been deleted by other means.

Soz, pal; you’re out of luck. :o(

Cheers,


Raymond

Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 24 July 2017 12:32
To: '[login to unmask email]'
Subject: [DB2-L] - RE: DB2 z/OS V10 DEFINE NO


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

**please note my email address change**
How… counterintuitive. Thanks for the info, Raymond.

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Bell, Raymond (IT Operations, Technology) [mailto:[login to unmask email]
Sent: Friday, July 21, 2017 9:39 PM
To: '[login to unmask email]'
Subject: [DB2-L] - RE: DB2 z/OS V10 DEFINE NO

Working as designed, I’m afraid. Nowhere is it recorded if a dataset physically exists (from memory). Either way, once one part is instantiated, they all are.

RFE time I’m afraid.

Cheers,


Raymond

Raymond Bell
DB2 Database Administrator | IT Operations | Technology | RBS

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 21 July 2017 18:02
To: '[login to unmask email]'
Subject: [DB2-L] - RE: DB2 z/OS V10 DEFINE NO


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************
**please note my email address change**
Did you try “INTO TABLE table-name PART n”?

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Mike Johnson [mailto:[login to unmask email]
Sent: Friday, July 21, 2017 12:51 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - DB2 z/OS V10 DEFINE NO


My client has a very large 1920 partition table space that I created using DEFINE NO to conserve DASD space. The problem is when I initially load the first partition it appears DB2 attempts to define all partitions datasets - not just the few I am loading.

Is there a way to prevent DB2 from allocating un-used datasets?

Thanks,

Mike J.

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (“RBS” or “us”) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you give your consent to the monitoring of your e-mail communications with us.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.


Visit our website at www.rbs.com http://www.rbs.com
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (“RBS” or “us”) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you give your consent to the monitoring of your e-mail communications with us.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.

Visit our website at www.rbs.com http://www.rbs.com
Attachments

  • image001.png (3.3k)

Mike Johnson

RE: DB2 z/OS V10 DEFINE NO
(in response to Raymond Bell)

Gents,

Thanks for the input.  What I'm going to do is initially define all the primary quantities for the partitions that will not be used for a number of months/years as 48/-1 (pri/sec) (same for the associated index partitions).

Regards,

Mike J

Philip Sevetson

DB2 z/OS V10 DEFINE NO
(in response to Mike Johnson)
**please note my email address change**
I _think_ that if you specify PRIQTY -1, DB2 will right-size the primary at REORGs. I haven’t tested that and I don’t recall where I read it. (Sorry.)

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Mike Johnson [mailto:[login to unmask email]
Sent: Monday, July 24, 2017 8:30 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 z/OS V10 DEFINE NO


Gents,

Thanks for the input. What I'm going to do is initially define all the primary quantities for the partitions that will not be used for a number of months/years as 48/-1 (pri/sec) (same for the associated index partitions).

Regards,

Mike J

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)