Enable ziip processing for hpunload



IBM's flagship relational database management system

Enable ziip processing for hpunload

Postby Soumya-forcobol » Tue Oct 06, 2020 4:12 pm

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
Soumya-forcobol
 
Posts: 3
Joined: Mon Oct 05, 2020 7:42 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Enable ziip processing for hpunload

 

Re: Enable ziip processing for hpunload

Postby Robert Sample » Tue Oct 06, 2020 7:13 pm

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!
Robert Sample
Global moderator
 
Posts: 3655
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 270 times

Re: Enable ziip processing for hpunload

Postby Soumya-forcobol » Tue Oct 06, 2020 7:19 pm

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
Soumya-forcobol
 
Posts: 3
Joined: Mon Oct 05, 2020 7:42 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Enable ziip processing for hpunload

Postby Robert Sample » Tue Oct 06, 2020 8:13 pm

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.

These users thanked the author Robert Sample for the post:
Soumya-forcobol (Tue Oct 06, 2020 8:30 pm)
Robert Sample
Global moderator
 
Posts: 3655
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 270 times

Re: Enable ziip processing for hpunload

Postby Soumya-forcobol » Wed Oct 07, 2020 2:57 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
Soumya-forcobol
 
Posts: 3
Joined: Mon Oct 05, 2020 7:42 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Enable ziip processing for hpunload

Postby Robert Sample » Wed Oct 07, 2020 6:45 pm

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.
Robert Sample
Global moderator
 
Posts: 3655
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 270 times


Return to DB2