Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen

------------------------------
Juergen Gleiss
------------------------------

Dear Juergen

What is the size of Temporary Space in the disk space report spooled file that you see? Please compare it against "Current temporary used" that you see from DSPSYSSTS screen to see if they differ by the amount you find differring or not?   

"Current temporary used" in DSPSYSSTS can vary a lot in the entire course of a day depending on the varying total workload your server carries at any moment.  In my experience, this temp disk allocation can vary as much as 500GB or more from one moment to another for a large total workload case.  The larger the total active workload, the larger the moment-to-moment fluctuation.  For example, if some jobs are joining many large tables (in SQL for example), IBM i would allocate more temp disk space to store the large result of the table join and then deallocate the space when the jobs are done with their data processing. 

So, expecting to see an exact or a very close match between the Disk Space report from RTVDSKINF and what you see from DSPSYSSTS can be a random chance at best.  You have better chance to see the match if your workload is small most of the time.   As the Greek said to Know Thyself, you need to know your workload  :-)   

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Wed February 14, 2024 03:04 AM
From: Juergen Gleiss
Subject: % System ASP used - How get Details? - Identify Disk increase

Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen

------------------------------
Juergen Gleiss
------------------------------

Hello Satid,

thanks for the detailed explanation.

Regards Jürgen

Dear Juergen

What is the size of Temporary Space in the disk space report spooled file that you see? Please compare it against "Current temporary used" that you see from DSPSYSSTS screen to see if they differ by the amount you find differring or not?   

"Current temporary used" in DSPSYSSTS can vary a lot in the entire course of a day depending on the varying total workload your server carries at any moment.  In my experience, this temp disk allocation can vary as much as 500GB or more from one moment to another for a large total workload case.  The larger the total active workload, the larger the moment-to-moment fluctuation.  For example, if some jobs are joining many large tables (in SQL for example), IBM i would allocate more temp disk space to store the large result of the table join and then deallocate the space when the jobs are done with their data processing. 

So, expecting to see an exact or a very close match between the Disk Space report from RTVDSKINF and what you see from DSPSYSSTS can be a random chance at best.  You have better chance to see the match if your workload is small most of the time.   As the Greek said to Know Thyself, you need to know your workload  :-)   

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Wed February 14, 2024 03:04 AM
From: Juergen Gleiss
Subject: % System ASP used - How get Details? - Identify Disk increase

Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen

------------------------------
Juergen Gleiss
------------------------------

"IF" the "Information collection" timestamp is current (as I mentioned in an earlier reply) then you could use the following to analyze temporary space 

QSYS2.SYSTMPSTG

See:  https://www.ibm.com/support/pages/ibm-i-services-sql

Sample:

--
-- Which active jobs are the top consumers of temporary storage?
--
SELECT bucket_current_size, bucket_peak_size, 
  rtrim(job_number) concat '/' 
  concat rtrim(job_user_name) 
  concat '/' 
  concat rtrim(job_name) as q_job_name 
FROM QSYS2.SYSTMPSTG 
WHERE job_status = '*ACTIVE' 
ORDER BY bucket_current_size desc;

Hello Satid,

thanks for the detailed explanation.

Regards Jürgen

Dear Juergen

What is the size of Temporary Space in the disk space report spooled file that you see? Please compare it against "Current temporary used" that you see from DSPSYSSTS screen to see if they differ by the amount you find differring or not?   

"Current temporary used" in DSPSYSSTS can vary a lot in the entire course of a day depending on the varying total workload your server carries at any moment.  In my experience, this temp disk allocation can vary as much as 500GB or more from one moment to another for a large total workload case.  The larger the total active workload, the larger the moment-to-moment fluctuation.  For example, if some jobs are joining many large tables (in SQL for example), IBM i would allocate more temp disk space to store the large result of the table join and then deallocate the space when the jobs are done with their data processing. 

So, expecting to see an exact or a very close match between the Disk Space report from RTVDSKINF and what you see from DSPSYSSTS can be a random chance at best.  You have better chance to see the match if your workload is small most of the time.   As the Greek said to Know Thyself, you need to know your workload  :-)   

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Wed February 14, 2024 03:04 AM
From: Juergen Gleiss
Subject: % System ASP used - How get Details? - Identify Disk increase

Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen

------------------------------
Juergen Gleiss
------------------------------

Hi Robert,

i know that this information is also available at IBM Navigator for i:
ibmhost:2002/Navigator/mainframe/system/temp-storage.

Regards Jürgen

"IF" the "Information collection" timestamp is current (as I mentioned in an earlier reply) then you could use the following to analyze temporary space 

QSYS2.SYSTMPSTG

See:  https://www.ibm.com/support/pages/ibm-i-services-sql

Sample:

--
-- Which active jobs are the top consumers of temporary storage?
--
SELECT bucket_current_size, bucket_peak_size, 
  rtrim(job_number) concat '/' 
  concat rtrim(job_user_name) 
  concat '/' 
  concat rtrim(job_name) as q_job_name 
FROM QSYS2.SYSTMPSTG 
WHERE job_status = '*ACTIVE' 
ORDER BY bucket_current_size desc;

Hello Satid,

thanks for the detailed explanation.

Regards Jürgen

Dear Juergen

What is the size of Temporary Space in the disk space report spooled file that you see? Please compare it against "Current temporary used" that you see from DSPSYSSTS screen to see if they differ by the amount you find differring or not?   

"Current temporary used" in DSPSYSSTS can vary a lot in the entire course of a day depending on the varying total workload your server carries at any moment.  In my experience, this temp disk allocation can vary as much as 500GB or more from one moment to another for a large total workload case.  The larger the total active workload, the larger the moment-to-moment fluctuation.  For example, if some jobs are joining many large tables (in SQL for example), IBM i would allocate more temp disk space to store the large result of the table join and then deallocate the space when the jobs are done with their data processing. 

So, expecting to see an exact or a very close match between the Disk Space report from RTVDSKINF and what you see from DSPSYSSTS can be a random chance at best.  You have better chance to see the match if your workload is small most of the time.   As the Greek said to Know Thyself, you need to know your workload  :-)   

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Wed February 14, 2024 03:04 AM
From: Juergen Gleiss
Subject: % System ASP used - How get Details? - Identify Disk increase

Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen

------------------------------
Juergen Gleiss
------------------------------

Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen

Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen

The first thing I would like to know:  Is the date/time of the following on your print disk report current?

Information collection start . . . . . . :   02/15/24  04:00:00
Information collection end . . . . . . . :   02/15/24  04:03:34

If not, then you need to run this BEFORE you print the information:  1. Collect disk space information

That takes some time to run.

Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen

Good Hint

The first thing I would like to know:  Is the date/time of the following on your print disk report current?

Information collection start . . . . . . :   02/15/24  04:00:00
Information collection end . . . . . . . :   02/15/24  04:03:34

If not, then you need to run this BEFORE you print the information:  1. Collect disk space information

That takes some time to run.

Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen

Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen

DSPASPBRM requires that you have the following installed on your system

5770BR1   *BASE    2924    Backup Recovery and Media Services for IBM i

Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen

PRTDSKINF RPTTYPE(*LIB) OBJ(*ALL) MINSIZE(99000) --> Thats great!

Can i retrieve the same information with sql or save it to a physical file?

------------------------------
Juergen Gleiss

Original Message:
Sent: Thu February 15, 2024 08:33 AM
From: Robert Berendt
Subject: % System ASP used - How get Details? - Identify Disk increase

DSPASPBRM requires that you have the following installed on your system

5770BR1   *BASE    2924    Backup Recovery and Media Services for IBM i

------------------------------
Robert Berendt IBMChampion

Original Message:
Sent: Wed February 14, 2024 03:04 AM
From: Juergen Gleiss
Subject: % System ASP used - How get Details? - Identify Disk increase

Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen

------------------------------
Juergen Gleiss
------------------------------

PRTDSKINF RPTTYPE(*LIB) OBJ(*ALL) MINSIZE(99000) --> Thats great!

Can i retrieve the same information with sql or save it to a physical file?

DSPASPBRM requires that you have the following installed on your system

5770BR1   *BASE    2924    Backup Recovery and Media Services for IBM i

Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen

PRTDSKINF RPTTYPE(*LIB) OBJ(*ALL) MINSIZE(99000) --> Thats great!

Can i retrieve the same information with sql or save it to a physical file?

DSPASPBRM requires that you have the following installed on your system

5770BR1   *BASE    2924    Backup Recovery and Media Services for IBM i

Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen

Hello everyone,

i am searching the details how % System-ASP is summed up from the dspsyssts command.

Because the report you get with "go disktasks" -->  "Print Disk Space Information" --> "System Information" does not match the amount from dspsyssts. The difference is 6%.

Is there a disk increase report available to identfy these objects or libraries?

Thanks Jürgen