INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Connect database from another machine?

Connect database from another machine?

(OP)
I've recently been given the task of extracting data from a DB2 database.

All I have are the files; and DB2 express. At least I *think* I have all the files... I have a folder called SQL00001 that has a bunch of sub-folders and large data files.

How can I "connect" to that database? I need to export everything out of it (they are updating their software to one that runs off of SQL server, and wants to get all of their historic data)

Any help is greatly appreciated!

TIA!

Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

RE: Connect database from another machine?

(OP)
I don't appear to have the unload command... either within DB2 or as a stand-alone executable. Does DB2 express have unload?

Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

RE: Connect database from another machine?

(OP)
If I can figure out how to connect and catalog to the existing files, then I can make an ODBC connection and grab all the data in Excel.

This thing is driving me crazy. Well, crazier.

Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

RE: Connect database from another machine?

what is the version of the database on the server, and what is the operating system hosting it - not the one you have on your pc as that should not be used most likely.

and did you search the manuals or just for a "utility executable" on your pc?

Regards

Frederico Fonseca
SysSoft Integrated Ltd
www.syssoft-int.com

FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?

RE: Connect database from another machine?

(OP)
I searched the manuals, and I searched google, and it's not part of the Windows distribution, it seems.

I have very limited access to the server. The customer essentially said "Here's all the files", and that's what I got.

Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

RE: Connect database from another machine?

not really a good move from the client to give you all the data - depending on the size of db's your db2 express may not even be able to read them completely.

so.. if their db is on a mainframe (Z/OS) the unload utility is a must use - very very fast extract of data and your client should know that.

if it is on another OS then look at http://www-01.ibm.com/support/knowledgecenter/SSEP... - I now think that the unload utility is not available outside Z/OS so the above would be one option

Other alternative, which may be slower so you will need to try it out is to use SSIS to connect to the DB and load the data to SQL Server.

in either case and depending on the charset of the source and the destination you may need to tweak the data so data is correct on the destination server.

Regards

Frederico Fonseca
SysSoft Integrated Ltd
www.syssoft-int.com

FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?

RE: Connect database from another machine?

(OP)
yes, the export command looks like it would do what I need... unfortunately the problem goes deeper than that.

I just have a folder with the data files. I've tried cataloging the folder (seems to work), but then a connect to says that it's an invalid path.

I don't know the schema, the tables, etc.

If I could _connect_ to the database, I could probably figure the rest out. Unfortunately, the DB2 errors are... cryptic at best.

Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

RE: Connect database from another machine?

(OP)
Just to follow up... I was able to access the server and export the data using the GUI. This made life MUCH easier.

Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close