No nicknames shown in control center V8.1.4

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • global
    #1

    No nicknames shown in control center V8.1.4

    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
    Tags: None
    • Serge Rielau
      #2
      Re: No nicknames shown in control center V8.1.4

      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

        Comment

        • Remove the obvious for replies
          #3
          Re: No nicknames shown in control center V8.1.4

          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 => ;LONGADATACOMPA T=1


          On 18 Dec 2003 06:09:59 -0800, anh.do-van@dak.de (global) wrote:
          [color=blue]
          >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[/color]

            Comment

            • PM \(pm3iinc-nospam\)
              #4
              Re: No nicknames shown in control center V8.1.4

              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/infocenter/db2help/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/infocenter/db2help/topic/com.ibm.db2.udb.doc/core/r0011121.htm



              PM

              "global" <anh.do-van@dak.de> a écrit dans le message de
              news:95b5b24d.0 312180609.7d240 597@posting.goo gle.com...[color=blue]
              > 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[/color]


                Comment

                • global
                  #5
                  Re: No nicknames shown in control center V8.1.4

                  Serge Rielau <srielau@ca.e ye-bee-m.com> wrote in message news:<brsg6g$kb i$2@hanover.tor olab.ibm.com>.. .[color=blue]
                  > 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[/color]

                  Bingo ! db2updv8 did help, thank you very much Serge

                    Comment

                    Previous template Next
                    Working...