Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Issue in unzip the PKZIP'ed Mainframe

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
Subbulakshmi yogesh

New User


Joined: 28 Sep 2011
Posts: 8
Location: india

PostPosted: Fri Nov 07, 2014 6:34 pm    Post subject: Issue in unzip the PKZIP'ed Mainframe
Reply with quote

I am ZIPing a flat file in Mainframe with PKZIP and the PKZIP parameters used as below,
-ECHO
-TEXT
-FILE_TERMINATOR()
-PATH(N)
-ARCHOUTDD(OUTARCH)
-INDD(INPUT)
FTp'ed the ZIPPed file to a Linux serverin Binary mode and was able to unzip the file properly.

Issue is when we try to load this Mainframe ZIPPed file from the linux server to REDSHIFT with copy command it gives error.

Is this issue related to the ZIP parameter? can anyone tell me do we need to add any special parameter while transferring to another envirnment.
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Nov 07, 2014 7:24 pm    Post subject: Re: Issue in unzip the PKZIP'ed Mainframe
Reply with quote

Subbulakshmi yogesh wrote:
Issue is when we try to load this Mainframe ZIPPed file from the linux server to REDSHIFT with copy command it gives error.

Is this issue related to the ZIP parameter? can anyone tell me do we need to add any special parameter while transferring to another envirnment.
Sorry but psychic day was Wednesday this week.

Looks like you may have to give us some information today so that we can possibly help at all. You know, silly little things like error codes and messages, what you have found out about these from google of where ever.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7904
Location: Bellevue, IA

PostPosted: Sat Nov 08, 2014 4:41 am    Post subject:
Reply with quote

One thing that comes to mind -- in the absence of any real data about the issue(s) -- is that mainframes use EBDIC while Linux / Windows machines usually use ASCII. You may need to convert your unzipped file to ASCII before the data will be recognized.
Back to top
View user's profile Send private message
Subbulakshmi yogesh

New User


Joined: 28 Sep 2011
Posts: 8
Location: india

PostPosted: Mon Nov 10, 2014 12:32 pm    Post subject: Reply to: Issue in unzip the PKZIP'ed Mainframe
Reply with quote

The error received at redshift end is,
error: Failed writing body (0 != 16384) Cause: Failed to inflateinvalid or incomplete deflate data. zlib error code: -3
code: 9001
context: S3 key being read : s3://XXX.gz
query: 223227
location: table_s3_scanner.cpp:348
process: query1_842 [pid=32285]


The file zipped at mainframe end and transfered to Linux box in binary mode is getting unzipped properly.

When we try to load the same ZIPed file to Redshift using copy command, getting the above error message.

My question here is,
do we need to add any special parameter during PKZIP while transferring to another environment say redshift.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Mon Nov 10, 2014 1:07 pm    Post subject: Reply to: Issue in unzip the PKZIP'ed Mainframe
Reply with quote

A quick internet search reveals a couple of other sites where it may be better to ask this question.
Back to top
View user's profile Send private message
Subbulakshmi yogesh

New User


Joined: 28 Sep 2011
Posts: 8
Location: india

PostPosted: Mon Nov 10, 2014 1:10 pm    Post subject:
Reply with quote

Bill,

Thanks for your suggestion. I posted this question in Redshift forums too.

Want to make sure, PKZIP parameter what i m using is correct and is there any special parameter to be used for other enivironment FTP transfer.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
No new posts DFHRESPONSE returns issue divated CICS 3 Wed Nov 02, 2016 6:32 pm
This topic is locked: you cannot edit posts or make replies. Mainframe Developer requirement in Ku... capricorn Mainframe Jobs 0 Sun Oct 23, 2016 3:49 pm
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm
No new posts Interface from Mainframe to Confluenc... hblun CLIST & REXX 4 Tue Sep 20, 2016 5:47 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us