DB2 Unload -Parameter + Version

itjagadesh · New User Joined: 05 Dec 2006 Posts: 89 Location: chennai

Hi All,

I have 2 doubts regarding DB2 Unload Utility.

1)In My production,we are using below version

INZU224I IBM DB2 HIGH PERFORMANCE UNLOAD V2.2
INZU219I PTFLEVEL=PK17548-Z206

But in Development we are using latest one i guess

INZU224I IBM DB2 HIGH PERFORMANCE UNLOAD V2.2
INZU219I PTFLEVEL=PK38404-Z256

could you please tell me what is INZU219I PTFLEVEL=? how can i chk that..

2)My second doubt is

While unloading DB2 table,below parameter is used

FORMAT VARAIBLE END

what is the meaning for format variable end?

Thanks
Jagadesh

Anuj Dhawan · Posted: Mon Jul 06, 2009 12:10 pm

Try your luck in these PDFs:

publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2tools.inz.doc.ug/inzhome.htm

www.google.co.in/search?hl=en&q=FORMAT+VARAIBLE+END+in+INZU224I+&meta=&aq=f&oq=

itjagadesh · New User Joined: 05 Dec 2006 Posts: 89 Location: chennai

Thanks Anuj for your Link provided.
But still i am not able to get infomation about.

"FORMAT VARIABLE END"
I am not sure of the use of above while unloading DB2 tables.
Can anyone give me explanation about the above parameter.

Thanks
Jagadesh

dbzTHEdinosauer · Posted: Mon Jul 06, 2009 4:54 pm

part of joining this community is attempting to do something on your part.

use the first link that Anuj gave you.

enter FORMAT VARIABLE END (and not FORMAT VARAIBLE END] in the search box
(left side of page)
and click on 'GO'.
now, start looking at the links provided.
Suggest you right click and open in a new tab
instead of just clicking on the link.
that way you will always have your search results.

itjagadesh · New User Joined: 05 Dec 2006 Posts: 89 Location: chennai

Hi Dick Brenholtz ,

I tried in that document.But not able to find proper definition of
"FORMAT VARIABLE END" parameter in DB2 Unload.(Given some example with that parameter..thats it)

Could anyone please tell me what will heppen if we specify above parameter along with Unload.

Thanks
Jagades

dick scherrer · Posted: Mon Jul 06, 2009 10:06 pm

Hello,