Enable ziip processing for hpunload

[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

[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!

[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

[Robert Sample]

The manual isn't as clear as it could be, that's for sure. However, try this:

Code: Select all

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.

[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

[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.