db2 client to connect to host databases and create/use local databases too

Cindy Ross

unread,

Apr 17, 2013, 12:31:10 PM4/17/13

to

Is it possible to install DB2 client product(s) so that the same system
can connect to host databases like DB2 Connect can, *and* can also
create and use local databases like DB2 Personal can?

I have "DB2 Personal Edition" installed now, which does everything I
want except I get an SQL8002N about missing DB2 Connect product/license
when I try to connect to an OS/400 database. I was thinking of trying
"DB2 Connect Personal Edition", but I cannot find confirmation anywhere
of whether that would let me also create and use local databases...

Helmut Tessarek

unread,

Apr 17, 2013, 1:14:10 PM4/17/13

to

Yes, "DB2 Connect Personal Edition" is the one you want.

--
Helmut K. C. Tessarek
DB2 Performance and Development
IBM Toronto Lab

Cindy Ross

unread,

Apr 17, 2013, 8:06:14 PM4/17/13

to

>> Is it possible to install DB2 client product(s) so that the same system
>> can connect to host databases like DB2 Connect can, *and* can also
>> create and use local databases like DB2 Personal can?
>>
>> I have "DB2 Personal Edition" installed now, which does everything I
>> want except I get an SQL8002N about missing DB2 Connect product/license
>> when I try to connect to an OS/400 database. I was thinking of trying
>> "DB2 Connect Personal Edition", but I cannot find confirmation anywhere
>> of whether that would let me also create and use local databases...
>
>Yes, "DB2 Connect Personal Edition" is the one you want.

Thanks, Helmut, but it doesn't seem to work for me.
I installed it, but when I try to CREATE DATABASE,
it says the command is not valid for the node type.

Helmut Tessarek

unread,

Apr 17, 2013, 8:29:50 PM4/17/13

to

On 17.04.13 20:06 , Cindy Ross wrote:
> Thanks, Helmut, but it doesn't seem to work for me.
> I installed it, but when I try to CREATE DATABASE,
> it says the command is not valid for the node type.

Ok, this is weird. Maybe the licensing has been changed at some point. The
last time I used Personal Connect was with version 5.2.

I'll figure it out and let you know.

Mark A

unread,

Apr 18, 2013, 2:57:03 AM4/18/13

to

On Wed, 17 Apr 2013 20:06:14 -0400, Cindy Ross wrote:

> Thanks, Helmut, but it doesn't seem to work for me. I installed it, but
> when I try to CREATE DATABASE, it says the command is not valid for the
> node type.

You cannot create a database with DB2 Connect, since it is only a client instance. If you have both the
DB2 server installed and DB2 Connect installed, you will have to run the command line from the DB2
server instance.

The easiest thing to do would probably been to just copy the DB2 Connect Licence file over to your DB2
database server instance. This assumes you are licensed for the DB2 Connect and have a valid license
file.

Cindy Ross

unread,

Apr 18, 2013, 7:43:10 AM4/18/13

to

Thanks, Helmut and Mark. Still trying to understand...

I don't have a server product installed. I did have
DB2 Personal Edition
which I used to create local databases, as well as access databases
running on db2 luw servers. But I could not use it to access os/400
databases.
So, I deinstalled it, replaced with
DB2 Connect Personal edition
But now I cannot create local databases, I get this:
SQL1096N The command is not valid for this node type.

I don't think I want to install server on this workstation,
but I would be willing to install both of these:
DB2 Personal Edition
DB2 Connect Personal Edition
I'm assuming I would install to separate sqllib directories?
And I would DB2 Personal Edition to create the databases only?
Then could use DB2 Connect Personal Edition to access *all* the
databases (luw servers, host servers, and even local ones once created)?

Is that the idea?

Helmut Tessarek

unread,

Apr 24, 2013, 1:40:15 PM4/24/13

to

Hi Cindy,

On 18.04.13 7:43 , Cindy Ross wrote:
> I don't think I want to install server on this workstation,
> but I would be willing to install both of these:
> DB2 Personal Edition
> DB2 Connect Personal Edition
> I'm assuming I would install to separate sqllib directories?
> And I would DB2 Personal Edition to create the databases only?
> Then could use DB2 Connect Personal Edition to access *all* the
> databases (luw servers, host servers, and even local ones once created)?
>
> Is that the idea?

Yes, sorry for the confusion. I made a mistake. I remembered local databases
on DB2 Connect Personal, but the databases I had in mind were actually
transaction databases for 2 phase commit.

You can install DB2 Personal Edition and add the license from DB2 Connect
Personal. (Mark already gave you this solution.)
In this case you can have local databases and use the same code to connect to
mainframe databases.

Cindy Ross

unread,

Apr 29, 2013, 8:42:27 AM4/29/13

to

>> I don't think I want to install server on this workstation,
>> but I would be willing to install both of these:
>> DB2 Personal Edition
>> DB2 Connect Personal Edition
>> I'm assuming I would install to separate sqllib directories?
>> And I would DB2 Personal Edition to create the databases only?
>> Then could use DB2 Connect Personal Edition to access *all* the
>> databases (luw servers, host servers, and even local ones once created)?
>>
>> Is that the idea?
>
>Yes, sorry for the confusion. I made a mistake. I remembered local databases
>on DB2 Connect Personal, but the databases I had in mind were actually
>transaction databases for 2 phase commit.
>
>You can install DB2 Personal Edition and add the license from DB2 Connect
>Personal. (Mark already gave you this solution.)
>In this case you can have local databases and use the same code to connect to
>mainframe databases.

Excellent. Thanks so much, Helmut and Mark!!!