Page 1 of 1
Enable ziip processing for hpunload
Posted:
Tue Oct 06, 2020 4:12 pm
by Soumya-forcobol
I am trying to perform an unload using the hpunload utility. Since there is an option ZIIP 100 to enable ziip processing I was trying the same
Sysin dd *
Unload tablespace
Db2 force parallelism(,32,) ZIIP=100
Select * from table name
But I get the error
Unload tablestatement : unexpected keyword
Fatal syntax error before line 2 column 39
Please help in fixing this error . The job runs fine without the Ziip keyword but I want to know how to enable ziip
Thankyou in advance
Re: Enable ziip processing for hpunload
Posted:
Tue Oct 06, 2020 7:13 pm
by Robert Sample
Read the manual. Try what it says -- such as first use a GLOBAL OPTIONS and get your job working with ZIIP=100 in there; only once you've gotten that running should you try anything else. I found the manual online and from what I read (I've never used the product and we don't even have DB2 installed on our mainframe), you have placed ZIIP=100 in the wrong place (which is what the syntax error tells you).
Furthermore, have you contacted the vendor for support? If not, why not -- they should be your FIRST line of contact for any product issues!
Re: Enable ziip processing for hpunload
Posted:
Tue Oct 06, 2020 7:19 pm
by Soumya-forcobol
Thankyou for your reply.
The problem is manual doesn’t give us the exact syntax. It just says place ZIIP=100 in sysin. I work as a contractor so I do not know how to contact the vendor directly.
Only think I am expecting from this group is help with the syntax
Re: Enable ziip processing for hpunload
Posted:
Tue Oct 06, 2020 8:13 pm
by Robert Sample
The manual isn't as clear as it could be, that's for sure. However, try this:
GLOBAL ZIIP=100 ;
Unload tablespace
Db2 force parallelism(,32,)
Select * from table name
although it might be ZIIP 100 (without the equals sign) -- if the program complains about the equals sign, take it out.
Re: Enable ziip processing for hpunload
Posted:
Wed Oct 07, 2020 2:57 pm
by Soumya-forcobol
Thankyou Robert
Global ziip 100; worked
Though it continued using the Core CPU and very less was offloaded to ziip. Looks like ziip 100 doesn’t actually mean 100% offload to ziip processors
Re: Enable ziip processing for hpunload
Posted:
Wed Oct 07, 2020 6:45 pm
by Robert Sample
Looks like ziip 100 doesn’t actually mean 100% offload to ziip processors
No, the manual specifically states that ZIIP 100 means to offload 100%
of the eligible workload to the zIIP processor. If the eligible workload is 5% of the total unload time, then you'll be dropping the CPU by 5% only.