DSNZPARM value - Clarification



IBM's flagship relational database management system

DSNZPARM value - Clarification

Postby jaggz » Thu Apr 19, 2012 9:43 am

Hi All,

Here I am trying set the MAXTEMPS to be the size of current 4k workspace. The IBM manual says the DSNZPARM value accepts in MB but when I convert 4K it looks to be very small value as 0.00391 MB.

Apology If my value conversion is wrong. Could anyone please point me the right value for the 4K.

Jaggz
User avatar
jaggz
 
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 4 times

Re: DSNZPARM value - Clarification

 

Re: DSNZPARM value - Clarification

Postby enrico-sorichetti » Thu Apr 19, 2012 11:13 am

What happened when You checked with Your hand calculator ?
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2648
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 132 times

Re: DSNZPARM value - Clarification

Postby jaggz » Thu Apr 19, 2012 11:30 am

Dear Enrico,

Here the 4K is not 4KB, but its the size on disk of all the 4k datasets.(4K size of Block). So I am not sure how it is expressed in MB.
User avatar
jaggz
 
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 4 times

Re: DSNZPARM value - Clarification

Postby enrico-sorichetti » Thu Apr 19, 2012 12:03 pm

that' s not what You asked ...
even if it was what was implied by the numbers You posted !

4KB expressed in MB are just that ...
4096 / 1048576
which gives
4kb = 0.00390625

if You intended to ask a different question, since we do not read minds :geek: ,
You should have worded Your question in a different way
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2648
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 132 times

Re: DSNZPARM value - Clarification

Postby BillyBoyo » Thu Apr 19, 2012 12:12 pm

A new online updatable DSNZPARM, MAXTEMPS, has been added to DSN6SYSP. This DSNZPARM specifies the maximum amount of workfile storage that an agent can use and is specified in units of MBs or GBs. If the DSNZPARM value is specified as 0, then no limit is enforced, which was the default in previous releases.


So your original fraction of a megabyte is not going to work.

If what you are saying is the you have 4K (as a unit) of 4KB lumps, that would be 16MB don't you think? 4000 * 4KB = 16000KB = 16MB.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post