IBM Mainframe Forum

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

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!

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

The manual isn't as clear as it could be, that's for sure. However, try this:although it might be ZIIP 100 (without the equals sign) -- if the program complains about the equals sign, take it out.

These users thanked the author Robert Sample for the post:

Soumya-forcobol (Tue Oct 06, 2020 8:30 pm)

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

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.