473,657 Members | 2,409 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

unload data on DB2 Z/OS to DB2 UDB on Windows

JAW
I have some tables on DB2 Z/OS 7.1 with SMALLINT, DECIMAL, TIMESTAMP,
DATE and CHAR datatypes.

I already have unload utilities crafted so I would just like to unload
some data on Z/OS for about 10 tables and then load them on the Windows
Server which runs DB2 UDB 8.2 .

My issue of course is with the NON-CHAR conversion.

Will using ASCII operand on Z/OS unload utility and then FTP'ing to
windows in Binary mode be the panecea?

Should I try to unload everything in basic CHAR format and FTP over in
ASCII and then do the load?

Suggestions?

Nov 12 '05 #1
4 10024
JAW wrote:
I have some tables on DB2 Z/OS 7.1 with SMALLINT, DECIMAL, TIMESTAMP,
DATE and CHAR datatypes.

I already have unload utilities crafted so I would just like to unload
some data on Z/OS for about 10 tables and then load them on the Windows
Server which runs DB2 UDB 8.2 .

My issue of course is with the NON-CHAR conversion.

Will using ASCII operand on Z/OS unload utility and then FTP'ing to
windows in Binary mode be the panecea?

Should I try to unload everything in basic CHAR format and FTP over in
ASCII and then do the load?

Suggestions?


Connect to database on z/OS from Windows Db2 client - use export --> import/load
method with .IXF format of export/import file.

Jan M. Nelken

Nov 12 '05 #2
JAW
Sounds like a good idea!

I would like to use the UNLOAD format since the data is going offsite
and not network time since the tables are large.

DB2 Unload in 7.1 does not appear to have the options on Platinum's
FASTUNLOAD where you can specify EXTERNAL on OUTPUT-FORMAT

Nov 12 '05 #3
JAW wrote:
Sounds like a good idea!

I would like to use the UNLOAD format since the data is going offsite
and not network time since the tables are large.

DB2 Unload in 7.1 does not appear to have the options on Platinum's
FASTUNLOAD where you can specify EXTERNAL on OUTPUT-FORMAT


ZIP works fine.

There is also separate product called DB2 High Performance Unload. Key is to use
..IXF format - so you can laod data to DB2 for Windows.

If you use Db2 client to connect to DB2 for z/OS in order to export data in IXF
- code page conversion is done for you. If you use IXF format - you do not need
to create tables on DB2 for Windows.

Jan M. Nelken
Nov 12 '05 #4
JAW
Jan,

Thanks!

I used the db2 -f command to export all of the Z/OS tables under a
certain user. I had to create a wrapper and server to point to the Z/OS
machine and then I created synonyms. It works great! The other way
worked also but it requires more work in crafting the load utility.

export to ab_pct_tbl.ixf of ixf messages msgs.txt select * from
db2admin.ab_pct _tbl ;
export to acs_tbl.ixf of ixf messages msgs.txt select * from
db2admin.acs_tb l ;
export to addresses.ixf of ixf messages msgs.txt select * from
db2admin.addres ses ;
export to aims_cntl_tran. ixf of ixf messages msgs.txt select * from
db2admin.aims_c ntl_tran ;

Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
20843
by: Harry J. Smith | last post by:
I have written a Visual Basic program that does a long calculation and writes the results to disk as it runs. If I click the Close button the window closes but the program keeps running. How can I get the program to recognize that its window has been closed and quit running? -Harry http://home.netcom.com/~hjsmith
1
3603
by: DB2 Novice | last post by:
Hi, What are the utils provided by IBM to fast load and unload DB2 in Unix and Windows env. I read about High Performance Unload and this is just Unload, waht about Load? What is the best way to dump a 2TB data? DB2Novice
0
4075
by: razheev | last post by:
Hi, I have a Table which contains 1 million rows. I want to do an unload of the table and do some massaging (tranforming) of data and do a load to a different table where the column attributes are different. My question is 1) What options should I use to do a unload so that the unload is very fast using Platinum Fast unload. The table has many columns which defined as VARCHAR. 2)Is there a provision to convert the column values from...
2
10844
by: Lauren Hines | last post by:
Hello, I have read numerous post stating that the only way to unload an assembly (DLL in my case) is to create a separate AppDomain, load the assembly, then unload it by calling AppDomain.Unload. When trying to delete the DLL file I get an exception that access is denied. When trying to copy over the DLL file, I get an exception that it is being used by another process.
2
6866
by: brianbender | last post by:
I am trying to load and unload assemblies dynamically and call methods and properties when loaded into an Appdomain I can load assemblies all day in the current AppDomain without references and without interfaces if need be. But try as I may they will ot unload. I have been working on this problem for weeks. I have seen other apps using Remoting but I know there has got to be a way to create a child AppDomain and reference obkect via...
3
3209
by: Gauthier Segay | last post by:
Hello, I've an application where all my pages implement a PAGE_CODE string property, this property is stored in HttpContext.Current.Items. In some page, I must persist data in session while the user perform operation on this page (postback navigation based). I also need to clean up the session data when the user leave the page (by a anyway). My question is about the Unload event, is it safe to use the unload
11
8637
by: Timofmars | last post by:
I'm try to Unload DB2 data from a table into a record sequential file on NT. I can an unload on Mainframe, but it doesn't seem to be an option in NT. In NT, all I can do is export/import. I can do a Load too, but not an Unload. I just want the only the data from the table in a record sequential file. Export seems only to give options to have a delimited line sequential file or a record sequential file where the data is preceeded by...
6
4720
by: Ronald S. Cook | last post by:
We have a Windows app that has one main form (a shell, sort of). We then load user controls into a panel on the form depending on what the user has selected. Our current code to unload the existing user control and load the newly selected one is pretty bulky. Every time we add a new user control to the project, we have to add some code in the section where we are loading/unloading. Is there a more dynamic, more efficient way to...
3
8566
by: Dan Holmes | last post by:
I have this DllImport attribute on an external C++ dll. What i am noticing that the dll isn't unloaded after the static method is complete. I was thinking that when the method (it is a static method) completed then the dll would be unloaded. Is there a way i can force this to unload or will i have to use loadlibrary? danny
0
8395
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8310
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8826
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8732
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
6166
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5632
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4306
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2726
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1615
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.