Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Location
    Tallahassee, FL
    Posts
    6

    Unanswered: Will 'db2rbind' cause db2 restart?

    Can anybody explain to me why I'm seeing the following message in db2diag.log? I did a 'db2rbind', but it looks like db2 got restarted even though I did not issue "db2stop / db2start".



    2008-05-14-14.47.59.599009-240 I70606G1507 LEVEL: Event
    PID : 12547 TID : 3086476992 PROC : db2start
    INSTANCE: db2prd2 NODE : 000
    FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
    DATA #1 : String, 36 bytes
    /db2home/db2prd2/sqllib/adm/db2star2
    DATA #2 : Hexdump, 256 bytes
    0xBFC46DD4 : 2F64 6232 686F 6D65 2F64 6232 7072 6432 /db2home/db2prd2
    0xBFC46DE4 : 2F73 716C 6C69 622F 6164 6D2F 6462 3273 /sqllib/adm/db2s
    0xBFC46DF4 : 7461 7232 004E 4F4D 5347 0000 0000 0000 tar2.NOMSG......
    0xBFC46E04 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0xBFC46E14 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0xBFC46E24 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0xBFC46E34 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0xBFC46E44 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0xBFC46E54 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0xBFC46E64 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0xBFC46E74 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0xBFC46E84 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0xBFC46E94 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0xBFC46EA4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0xBFC46EB4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0xBFC46EC4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    It is not supposed to. I have a cron job that runs once a month that does runstats then does db2rbind. It works like a charm.

    It is probably a combination of things that is causing it. A while back we had a stored procedure (package) that if you did a REBIND on it, it would crash the instance. It was a problem with a specific FP, and the next one fixed the issue.

    What DB2 version, FP, and OS are you using?

    Andy

  3. #3
    Join Date
    Apr 2004
    Location
    Tallahassee, FL
    Posts
    6
    Thanks, Andy.

    We have UDB V8.1 with FP 16, on RedHat Linux 2.6.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Redhat linux 2.6??????????????

    Is that the part of the kernel version?

    Do you mean RHEL 4 or RHEL 5?

    Andy

  5. #5
    Join Date
    Sep 2010
    Posts
    1

    in tripsher

    The 'db2star' is not a real db2start. It's just some harmless msg from the engine. I get them time to time.

Posting Permissions

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