Professional Web Applications Themes

FixPak 10 and CREATE SERVER - IBM DB2

Hi. Having searched on Web sites for a while without much gain, I decided to post here. I've been using DB2 V7.2 UDB for Linux on a test server at work, to see if DB2's federation feature meets our requirements. After having applied FixPak 10 (U488497), issuing 'CREATE SERVER' statement causes DB instance to crash. The configuration is quite trivial; a simple federation via DRDA wrapper, and the full statement looks something like this: CREATE SERVER foosrv type DB2/Linux version 7.2.8 WRAPPER DRDA AUTHORIZATION user PASSWORD pass OPTIONS ( node 'foo', dbname 'dbfoo' ) massive messages are written to db2diag.log, ...

  1. #1

    Default FixPak 10 and CREATE SERVER

    Hi.
    Having searched on Web sites for a while without much gain,
    I decided to post here.
    I've been using DB2 V7.2 UDB for Linux on a test server at work,
    to see if DB2's federation feature meets our requirements.
    After having applied FixPak 10 (U488497), issuing 'CREATE SERVER'
    statement causes DB instance to crash. The configuration is quite
    trivial; a simple federation via DRDA wrapper, and the full
    statement looks something like this:
    CREATE SERVER foosrv type DB2/Linux version 7.2.8
    WRAPPER DRDA AUTHORIZATION user PASSWORD pass
    OPTIONS ( node 'foo', dbname 'dbfoo' )

    massive messages are written to db2diag.log, including the local database
    (to which CREATE SERVER was issued) was marked damaged. The local database
    can be restart with db2start without problem.

    With FixPak 9, DB2 won't crash(I even verified this by reinstalling
    V7.2 and FixPak 9), and federation works as expected. I also verified
    that the minor versions of remote server doesn't affect the result.
    V8.1+FP3 doesn't seem to crash either, but we haven't decided whether
    we can migrate our production servers to V8.1, so this isn't an option.

    I've also looked into HIPER APAR alerts, but found nothing seemed
    relavant. Any information is appreciated.

    Regards,
    Yonetani.
    YONETANI Tomokazu Guest

  2. #2

    Default Re: FixPak 10 and CREATE SERVER

    Maybe you can find something in some of those posts.

    [url]http://groups.google.ca/groups?q=%28federated+OR+federation%29+AND+create+ AND+server+group%3Acomp.databases.ibm-db2+group%3Acomp.databases.ibm-db2&hl=en&lr=&ie=ISO-8859-1&scoring=d[/url]



    PM


    PM \(pm3iinc-nospam\) Guest

  3. #3

    Default Re: FixPak 10 and CREATE SERVER

    "PM \(pm3iinc-nospam\)" <Pm3iinc.NoSpamsympatico.ca> wrote in message news:<PXZ9b.2191$mv6.392528news20.bellglobal.com> ...
    > Maybe you can find something in some of those posts.
    >
    > [url]http://groups.google.ca/groups?q=%28federated+OR+federation%29+AND+create+ AND+server+group%3Acomp.databases.ibm-db2+group%3Acomp.databases.ibm-db2&hl=en&lr=&ie=ISO-8859-1&scoring=d[/url]
    Thanks for the response. However, this is exactly the search I did before
    posting the first message here. I've read through all the hits again, but
    found nothing relavant. Most messages in above search are posted more than
    6 months before, but the problem here is specific to FixPak 10. Here's

    $ db2 connect to test

    Database Connection Information

    Database server = DB2/LINUX 7.2.8
    SQL authorization ID = DB2INST1
    Local database alias = TEST

    $ db2 "create server trivia type db2/linux version '7.2.7'
    wrapper drda options ( node 'trivia', dbname 'db2inst1' )"
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0902C A system error (reason code = "255") occurred. Subsequent SQL
    statements cannot be processed. SQLSTATE=58005
    $ db2 list tables
    SQL1024N A database connection does not exist. SQLSTATE=08003

    See? I didn't even give the authorization, but it just crashed.
    Output from tcpdump shows that no single packet is sent out before
    the connection to the DB 'test' died out.
    'trivia' is the name of the remote DB2 server, and tcpip catalog is
    setup properly and I can connect to trivia from the same machine
    via the tcpip catalog.
    I've just received a DB2 Alert regarding FixPak10a, but the APAR list
    didn't mention this breakage.

    Yonetani
    YONETANI Tomokazu Guest

  4. #4

    Default Re: FixPak 10 and CREATE SERVER

    Larry Edelstein <lsedelsus.ibm.com> wrote in message news:<3F673A0F.1A43D04Eus.ibm.com>...
    > Can you tell us what the instance throws when it does this? What error msg or
    > error code?
    Ok, but the number of lines is big, so I'm going to omit some of them.
    Please tell me something important is missing.
    The password below is well-known default and we're not using it on
    production servers.
    Also please note that my mailbox is currently filled up by w32.Gibe,
    so if you try to send me something privately, it may be bounced back
    to you.

    Regards.

    $ cat /etc/redhat-release
    Red Hat Linux release 7.3 (Valhalla)
    $ uname -mprs
    Linux 2.4.22-pre1 i586 unknown
    $ tail -n 0 -f ~db2inst1/sqllib/db2dump/db2diag.log > aaaaa &
    $ db2 "create server trivia type DB2/Linux version 7.2.7 wrapper drda
    authorization db2inst1 password ibmdb2 options ( node 'trivia', dbname
    'db2log', dbpass 'ibmdb2')"
    DB21034E The command was processed as an SQL statement because it was
    not a
    valid Command Line Processor command. During SQL processing it
    returned:
    SQL0902C A system error (reason code = "255") occurred. Subsequent
    SQL
    statements cannot be processed. SQLSTATE=58005

    $ less aaaaa

    2003-09-22-11.39.47.682534 Instance:db2inst1 Node:000
    PID:19331(db2agent (SMAPLE)) Appid:*LOCAL.db2inst1.030922023852
    global_services sqlzerdm Probe:40 Database:SMAPLE

    ffff ffff ....


    2003-09-22-11.39.47.892145 Instance:db2inst1 Node:000
    PID:19331(db2agent (SMAPLE)) Appid:*LOCAL.db2inst1.030922023852
    relation_data_serv sqlrr_signal_handler Probe:10 Database:SMAPLE
    DIA7107I 構成要素シグナル・ハ"ドル"\の実行が開始されてい ます。
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:APM COMMON INFO
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:PACKAGE ENTRY
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:USED_IN_UOW BIT
    VECTOR
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:Recursive
    dump_sect
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:SECTION NUMBER
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:SECTION DIR
    ENTRY
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:cache cb

    Data Title:section stmt PID:19331 Node:000
    6372 6561 7465 2073 6572 7665 7220 7472 create server tr
    [omit dump of SQL statement]

    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:section stmt
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:sentptr
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000
    Data:sentptr->sectlen
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000
    Data:sentptr->cache_cb
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000
    Data:sentptr->cache_cb->cached_sectptr
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000
    Data:sentptr->cache_cb->cached_sectptr->thread_list
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:calculated
    section size (1): not including thread list
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:calculated
    section size(2): including thread structure
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:thd_table
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:thd_table->size
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:calculated
    section size(3): including thread list table
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:the_section
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:Relocated
    section
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:Section
    relocated; reltables dumped
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:section ptr
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:section size
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:dynamic ptr
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:dynamic size
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:shared dynamic
    ptr
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:shared dynamic
    size
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:dynamic section
    header
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:offset in
    section
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:opcode
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:agg_mode
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:section1
    Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:dynamic buffer
    [suppressed]
    YONETANI Tomokazu Guest

  5. #5

    Default Re: FixPak 10 and CREATE SERVER

    Did some quick searches and couldn't come up with anything. The error msg itself seems to
    indicate a problem with the Federated source. I assume that if you are specifying a DRDA server,
    then

    1) you have defined and proven connectivity directly to that server without using the federated
    feature, i.e. you can connect directly to that backend server?
    2) that you have already created/defined the DRDA wrapper?

    If you have, then it is quite possible you have encountered a new bug. Unless someone else on
    the list can make a better suggestion, you might want to consider opening a PMR with IBM
    support.

    Larry Edelstein

    YONETANI Tomokazu wrote:
    > Larry Edelstein <lsedelsus.ibm.com> wrote in message news:<3F673A0F.1A43D04Eus.ibm.com>...
    > > Can you tell us what the instance throws when it does this? What error msg or
    > > error code?
    >
    > Ok, but the number of lines is big, so I'm going to omit some of them.
    > Please tell me something important is missing.
    > The password below is well-known default and we're not using it on
    > production servers.
    > Also please note that my mailbox is currently filled up by w32.Gibe,
    > so if you try to send me something privately, it may be bounced back
    > to you.
    >
    > Regards.
    >
    > $ cat /etc/redhat-release
    > Red Hat Linux release 7.3 (Valhalla)
    > $ uname -mprs
    > Linux 2.4.22-pre1 i586 unknown
    > $ tail -n 0 -f ~db2inst1/sqllib/db2dump/db2diag.log > aaaaa &
    > $ db2 "create server trivia type DB2/Linux version 7.2.7 wrapper drda
    > authorization db2inst1 password ibmdb2 options ( node 'trivia', dbname
    > 'db2log', dbpass 'ibmdb2')"
    > DB21034E The command was processed as an SQL statement because it was
    > not a
    > valid Command Line Processor command. During SQL processing it
    > returned:
    > SQL0902C A system error (reason code = "255") occurred. Subsequent
    > SQL
    > statements cannot be processed. SQLSTATE=58005
    >
    > $ less aaaaa
    >
    > 2003-09-22-11.39.47.682534 Instance:db2inst1 Node:000
    > PID:19331(db2agent (SMAPLE)) Appid:*LOCAL.db2inst1.030922023852
    > global_services sqlzerdm Probe:40 Database:SMAPLE
    >
    > ffff ffff ....
    >
    > 2003-09-22-11.39.47.892145 Instance:db2inst1 Node:000
    > PID:19331(db2agent (SMAPLE)) Appid:*LOCAL.db2inst1.030922023852
    > relation_data_serv sqlrr_signal_handler Probe:10 Database:SMAPLE
    > DIA7107I 構成要素シグナル・ハ"ドル"\の実行が開始されてい ます。
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:APM COMMON INFO
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:PACKAGE ENTRY
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:USED_IN_UOW BIT
    > VECTOR
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:Recursive
    > dump_sect
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:SECTION NUMBER
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:SECTION DIR
    > ENTRY
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:cache cb
    >
    > Data Title:section stmt PID:19331 Node:000
    > 6372 6561 7465 2073 6572 7665 7220 7472 create server tr
    > [omit dump of SQL statement]
    >
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:section stmt
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:sentptr
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000
    > Data:sentptr->sectlen
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000
    > Data:sentptr->cache_cb
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000
    > Data:sentptr->cache_cb->cached_sectptr
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000
    > Data:sentptr->cache_cb->cached_sectptr->thread_list
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:calculated
    > section size (1): not including thread list
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:calculated
    > section size(2): including thread structure
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:thd_table
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:thd_table->size
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:calculated
    > section size(3): including thread list table
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:the_section
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:Relocated
    > section
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:Section
    > relocated; reltables dumped
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:section ptr
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:section size
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:dynamic ptr
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:dynamic size
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:shared dynamic
    > ptr
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:shared dynamic
    > size
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:dynamic section
    > header
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:offset in
    > section
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:opcode
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:agg_mode
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:section1
    > Dump File:/home/db2inst1/sqllib/db2dump/19331.000 Data:dynamic buffer
    > [suppressed]
    Larry Edelstein Guest

  6. #6

    Default Re: FixPak 10 and CREATE SERVER

    Larry Edelstein <lsedelsus.ibm.com> wrote in message news:<3F6E77FA.BEC45CC8us.ibm.com>...
    > Did some quick searches and couldn't come up with anything. The error msg
    > itself seems to indicate a problem with the Federated source. I assume
    > that if you are specifying a DRDA server, then
    >
    > 1) you have defined and proven connectivity directly to that server
    > without using the federated feature, i.e. you can connect directly to
    > that backend server?
    > 2) that you have already created/defined the DRDA wrapper?
    Yes. And it doesn't crash if FixPak9 is installed.
    I also tried FixPak10a but no luck.
    > If you have, then it is quite possible you have encountered a new bug.
    > Unless someone else on the list can make a better suggestion, you might
    > want to consider opening a PMR with IBM support.
    I'll try it later.
    Thanks.
    YONETANI Tomokazu Guest

  7. #7

    Default Re: FixPak 10 and CREATE SERVER

    Hi.

    Larry Edelstein <ibm.com> wrote in message news:<ibm.com>... 

    Done.
    It took me a few days to understand what I need to do to file a PMR,
    and the web server behind www-925 seemed to be quite busy; I've encountered
    a lot of "proxy error"s.

    Thanks.
    YONETANI Guest

Similar Threads

  1. Replies: 0
    Last Post: August 15th, 09:24 AM
  2. How to Create Web Server in Windows 2003 Advanced Server?
    By Rajesh Khadka in forum ASP.NET Web Services
    Replies: 0
    Last Post: May 19th, 10:07 AM
  3. Intersting fixpak situation
    By Tim V. in forum IBM DB2
    Replies: 1
    Last Post: September 11th, 03:42 PM
  4. DB2 V7 Fixpak 10 - problem with command line
    By Damir Wilder in forum IBM DB2
    Replies: 2
    Last Post: August 29th, 12:45 PM
  5. Win2000: CLI0157E, Error Opening a File, UDB v7, Fixpak 7
    By SAP BASIS Consultant in forum IBM DB2
    Replies: 2
    Last Post: August 26th, 06:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139