RE: DB2 Control Center: Is that for DB2 on IBM i also? -- MIDRANGE-L

Yes - I have client access installed. Version 6.0 for Windows.

Window XP/Pro version - 64bit.

The following screen is what I get with the error:

[cid:image001.png@01CEE87C.E63AE050]

As you can see - once the transfer starts - it gets the message: (Not Responding).

However, I found if I let the transfer continue to run - eventually it completes with the following pop-up screen:

[cid:image002.png@01CEE87D.75489490]

The .CSV is created - but the message is annoying.

Charles Pascoe

Programming Supervisor

cpascoe@xxxxxxxxxxxxxxxxx

Neurotics build castles in the sky. Psychotics live in them. Psychiatrists collect the rent.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bdietz400
Sent: November 23, 2013 7:18 AM
To: Midrange Systems Technical Discussion
Cc: Midrange Systems Technical Discussion
Subject: Re: DB2 Control Center: Is that for DB2 on IBM i also?

I have not had that problem with that program. I have used with CA v5r4 thru v7.1 and xp ans win7(64).

Questions, do you have client access installed? What version of windows?

--

Bryan

On Nov 22, 2013, at 9:02 AM, Charles Pascoe <cpascoe@xxxxxxxxxxxxxxxxx<mailto:cpascoe@xxxxxxxxxxxxxxxxx>> wrote:

Thanks for the link to the IBM site.

We are on V5R4M5.

I downloaded the .exe (IbmiTransfer.exe) - it installed ok.

When I execute it - it fails with message (on pop-up transfer screen) "Column Heading Transfer(Not Responding)".

Only option I have is to cancel the transfer.

Is there something else that needs to be installed for this to work?

Charles Pascoe

Programming Supervisor

cpascoe@xxxxxxxxxxxxxxxxx<mailto:cpascoe@xxxxxxxxxxxxxxxxx>

Neurotics build castles in the sky. Psychotics live in them. Psychiatrists collect the rent.

-----Original Message-----

From: midrange-l-bounces@xxxxxxxxxxxx

[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bdietz400

Sent: November 22, 2013 1:05 AM

To: Midrange Systems Technical Discussion

Cc: midrange-l@xxxxxxxxxxxx

Subject: Re: DB2 Control Center: Is that for DB2 on IBM i also?

I wonder if using the IBM i transfer tool would help.

http://public.dhe.ibm.com/services/us/igsc/cs2/ApiSamples/

Look for IbmiTransfer.exe

I use it frequently for downloading ad hoc data in csv format.

--

Bryan

On Nov 20, 2013, at 3:44 PM, rob@xxxxxxxxx<mailto:rob@xxxxxxxxx> wrote:

I have a ticket opened with IBM Sametime. They want me to use DB2

Control Center to export some tables from the database for Sametime.

This is the WAS based Sametime and yes, it does store some data in

the qsys.lib file system. Admittedly this gentleman is unfamiliar

with

DB2 on IBM i but he believes that DB2 Control Center is a client that

runs on Windows or Linux clients and can access DB2 on multiplatforms

(including IBM i). I don't think he's actually ever used it to

access

db2 on IBM i. Well, I am thinking that there must be other ways to

skin this cat. He's wanting it exported to a delimited file. I

figure I could use File Transfer but I wondered if the database

portion of the fat client System i Navigator would have an 'Export' function in the tables part of database. Nope.

Figuring that is deprecated I tried the web version IBM Navigator for

i and that does have an Export function. Their Export function is

much like CPYTOIMPF (which everyone knows is just my FAVE!). It

copies the file into the stream file system, not to your client. It

does have some enhancements, like the datalink and other different

columns allow you to CAST them. The screen goes into something like:

...

normalCharacterColumn,

normalNumericColumn,

/* datalinkorclobColumn */,

...

I change that one line to

CAST (datalinkorclobColumn as char (128)) as

datalinkorclobColumnChar, ...

Now, if it just didn't error out and hang... Oh well, now I am up to

10 open pmr's. Of which one could be career threatening.

So, is it just a bad trip to think that 'DB2 Control Center' is a

possible solution?

Rob Berendt

--

IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600

Mail to: 2505 Dekko Drive

Garrett, IN 46738

Ship to: Dock 108

6928N 400E

Kendallville, IN 46755

http://www.dekko.com

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L)

mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxx> To

subscribe, unsubscribe, or change list options,

visit: http://lists.midrange.com/mailman/listinfo/midrange-l

or email: MIDRANGE-L-request@xxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxx> Before posting, please take

a moment to review the archives at

http://archive.midrange.com/midrange-l.

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list To post a message email: MIDRANGE-L@xxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxx> To subscribe,

unsubscribe, or change list options,

visit: http://lists.midrange.com/mailman/listinfo/midrange-l

or email: MIDRANGE-L-request@xxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxx> Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list To post a message email: MIDRANGE-L@xxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxx> To subscribe,

unsubscribe, or change list options,

visit: http://lists.midrange.com/mailman/listinfo/midrange-l

or email: MIDRANGE-L-request@xxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxx> Before posting, please take

a moment to review the archives at

http://archive.midrange.com/midrange-l.

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxx> To subscribe, unsubscribe, or change list options,

visit: http://lists.midrange.com/mailman/listinfo/midrange-l

or email: MIDRANGE-L-request@xxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxx> Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.