No nicknames shown in control center V8.1.4

[global]

Hi,
we have UDB 8.1.4 on W2K and defined federated database
with nicknames, which cann't be seen in control center.
(filter is not activ).
Thx

[Serge Rielau]

Hi,

Were they shown before? Did you run db2updv8?
cc requires db2updv8 to be run before dealing with DB2 II properly since
it needs a new procedure registered in SYSCAT.ROUTINES.
(this was discussed a few montsh ago in this groups actually)

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Remove the obvious for replies]

Also,

If you are looking at them remotely, make sure to comment out the line

LONGADATACOMPAT=1

your db2cli.ini file.

i.e.

LONGADATACOMPAT=1 => ;LONGADATACOMPAT=1
On 18 Dec 2003 06:09:59 -0800, an********@dak.de (global) wrote:

Hi,
we have UDB 8.1.4 on W2K and defined federated database
with nicknames, which cann't be seen in control center.
(filter is not activ).
Thx

[PM \(pm3iinc-nospam\)]

Maybe you fit this situation?

For users of DB2 Universal Database for Linux, UNIX, and Windows Version 7.2
federated databases

To create nicknames for tables and views in DB2 Universal Database (DB2 UDB)
for UNIX and Windows, Version 8, you need to apply DB2 UDB for UNIX and
Windows Version 7.2 FixPak 8 on your DB2 UDB for UNIX and Windows Version
7.2 federated database. If you do not apply FixPak 8 on your DB2 UDB for
UNIX and Windows Version 7.2 federated database, an error will occur when
you access the nicknames.

http://publib.boulder.ibm.com/infoce...help/index.jsp
Release Notes (Version 8.1.4)

Known problems and workarounds (Version 8.1.4)

See

Federated systems restrictions
http://publib.boulder.ibm.com/infoce...e/r0011121.htm
PM

"global" <an********@dak.de> a écrit dans le message de
news:95**************************@posting.google.c om...

Hi,
we have UDB 8.1.4 on W2K and defined federated database
with nicknames, which cann't be seen in control center.
(filter is not activ).
Thx

[global]

Serge Rielau <sr*****@ca.eye-bee-m.com> wrote in message news:<br**********@hanover.torolab.ibm.com>...

Hi,

Were they shown before? Did you run db2updv8?
cc requires db2updv8 to be run before dealing with DB2 II properly since
it needs a new procedure registered in SYSCAT.ROUTINES.
(this was discussed a few montsh ago in this groups actually)

Cheers
Serge

Bingo ! db2updv8 did help, thank you very much Serge