| re: db2_all returns completed rc=0 with no output
Sorry JS, I meant could you send me the trace (both the format and flow).
--
Garfield A. Lewis
DB2 UDB Development,
IBM Canada Laboratory
"JS" <fyi85@hotmail.com> wrote in message
news:e9c166ca.0406140741.1455344a@posting.google.c om...[color=blue]
> "Garfield Lewis" <galewis@SPAM-NO-MOREca.ibm.com> wrote in message[/color]
news:<cace2b$si6$1@hanover.torolab.ibm.com>...[color=blue][color=green]
> > Hi JS,
> >
> > Can you get a trace from one of the <HOSTNAME> machines?
> >
> > --
> > Garfield A. Lewis
> > DB2 UDB Development,
> > IBM Canada Laboratory
> >
> >
> > "JS" <fyi85@hotmail.com> wrote in message
> > news:e9c166ca.0406091224.73ebdc51@posting.google.c om...[color=darkred]
> > > windows 2k with v 8 fix 5, eee set up
> > > when I issue db2_all "db2 get db cfg for <dbname>", I get for each[/color][/color][/color]
node:[color=blue][color=green][color=darkred]
> > > <HOSTANME> : DB2 GET DB CFG FOR <DBNAME> completed RC=0
> > > rah: <HOSTNAME>
> > > but there is no screen output for any of the nodes.
> > > Any idea how to make this work?[/color][/color]
>
> Trace from node 0 machine, no db connections, execute
> db2_all "db2 get db cfg for <dbname>"
> profile entries have been deleted from this listing
>
> 1 entry DB2 SQO Memory Management sqloFreeOSSInternalMemory cei[/color]
(1.3.128.23.2)[color=blue]
> pid 2124 tid 3236 cpid -1 node -1 sec 0 nsec 0
>
> 2 entry DB2 SQO Memory Management sqloFreePrivateSet cei (1.3.128.24.2)
> pid 2124 tid 3236 cpid -1 node -1 sec 0 nsec 45
>
> 3 exit DB2 SQO Memory Management sqloFreePrivateSet cei (2.3.128.24.2)
> pid 2124 tid 3236 cpid -1 node -1 sec 0 nsec 55
> rc = 0
>
> 4 exit DB2 SQO Memory Management sqloFreeOSSInternalMemory cei[/color]
(2.3.128.23.2)[color=blue]
> pid 2124 tid 3236 cpid -1 node -1 sec 0 nsec 252
> rc = 0
>
> 5 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 2565150
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 6 exit DB2 oper system services sqloWaitIPCWaitPost cei (2.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 2565166
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 7 entry DB2 oper system services sqloWaitIPCWaitPost cei (1.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 2565217
>
> 8 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 2565233
>
> 9 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 3212 tid 2272 cpid 868 node 0 sec 0 nsec 4194756
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 10 exit DB2 oper system services sqloWaitIPCWaitPost cei (2.3.15.557.2)
> pid 3212 tid 2272 cpid 868 node 0 sec 0 nsec 4194771
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 11 data DB2 lock manager sqlpldl fnc (3.3.35.5.0.2)
> pid 3212 tid 2272 cpid 868 node 0 sec 0 nsec 4194791 probe 2
> bytes 4
> 7F000000 ....
>
> 12 data DB2 lock manager sqlpldl fnc (3.3.35.5.0.130)
> pid 3212 tid 2272 cpid 868 node 0 sec 0 nsec 4194949 probe 130
> bytes 1
> 00 .
>
> 13 entry DB2 oper system services sqloWaitIPCWaitPost cei (1.3.15.557.2)
> pid 3212 tid 2272 cpid 868 node 0 sec 0 nsec 4194960
>
> 14 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 3212 tid 2272 cpid 868 node 0 sec 0 nsec 4194976
>
> 15 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 5860 tid 5624 cpid -1 node 0 sec 0 nsec 6490978
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 16 exit DB2 oper system services sqlorque cei (2.3.15.828.2)
> pid 5860 tid 5624 cpid -1 node 0 sec 0 nsec 6491077
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 17 entry DB2 oper system services sqlorque cei (1.3.15.828.2)
> pid 5860 tid 5624 cpid -1 node 0 sec 0 nsec 6491295
>
> 18 data DB2 oper system services sqlorque cei (3.3.15.828.2.5)
> pid 5860 tid 5624 cpid -1 node 0 sec 0 nsec 6491301 probe 5
> bytes 64
> 01000100 C0010000 3005E400 8403FD00 ........0.......
> C4010000 4442324D 50503052 31313333 ....DB2MPP0R1133
> 32323434 35300000 00000000 00000000 224450..........
> 00000000 00000000 00000000 00000000 ................
>
> 19 data DB2 oper system services sqlorque cei (3.3.15.828.2.6)
> pid 5860 tid 5624 cpid -1 node 0 sec 0 nsec 6491315 probe 6
> bytes 4
> 44040000 D...
>
> 20 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 5860 tid 5624 cpid -1 node 0 sec 0 nsec 6491333
>
> 21 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 6903673
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 22 exit DB2 oper system services sqloWaitIPCWaitPost cei (2.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 6903690
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 23 entry DB2 oper system services sqloWaitIPCWaitPost cei (1.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 6903737
>
> 24 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 6903753
>
> 25 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 11242208
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 26 exit DB2 oper system services sqloWaitIPCWaitPost cei (2.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 11242223
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 27 entry DB2 oper system services sqloWaitIPCWaitPost cei (1.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 11242275
>
> 28 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 11242292
>
> 29 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 15580733
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 30 exit DB2 oper system services sqloWaitIPCWaitPost cei (2.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 15580749
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 31 entry DB2 oper system services sqloWaitIPCWaitPost cei (1.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 15580799
>
> 32 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 15580815
>
> 33 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 19919256
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 34 exit DB2 oper system services sqloWaitIPCWaitPost cei (2.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 19919271
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 35 entry DB2 oper system services sqloWaitIPCWaitPost cei (1.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 19919319
>
> 36 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 19919335
>
> 37 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 24257792
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 38 exit DB2 oper system services sqloWaitIPCWaitPost cei (2.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 24257810
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 39 entry DB2 oper system services sqloWaitIPCWaitPost cei (1.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 24257859
>
> 40 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 24257875
>
> 41 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 28596321
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 42 exit DB2 oper system services sqloWaitIPCWaitPost cei (2.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 28596337
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 43 entry DB2 oper system services sqloWaitIPCWaitPost cei (1.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 28596385
>
> 44 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 28596401
>
> 45 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 32934861
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 46 exit DB2 oper system services sqloWaitIPCWaitPost cei (2.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 32934875
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 47 entry DB2 oper system services sqloWaitIPCWaitPost cei (1.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 32934920
>
> 48 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 32934935
>
> 49 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 5860 tid 5624 cpid -1 node 0 sec 0 nsec 33580333
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 50 exit DB2 oper system services sqlorque cei (2.3.15.828.2)
> pid 5860 tid 5624 cpid -1 node 0 sec 0 nsec 33580454
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 51 entry DB2 oper system services sqlorque cei (1.3.15.828.2)
> pid 5860 tid 5624 cpid -1 node 0 sec 0 nsec 33580678
>
> 52 data DB2 oper system services sqlorque cei (3.3.15.828.2.5)
> pid 5860 tid 5624 cpid -1 node 0 sec 0 nsec 33580684 probe 5
> bytes 64
> 01000100 C0010000 3005E400 8403FD00 ........0.......
> C4010000 4442324D 50503052 31313333 ....DB2MPP0R1133
> 32323434 35300000 00000000 00000000 224450..........
> 00000000 00000000 00000000 00000000 ................
>
> 53 data DB2 oper system services sqlorque cei (3.3.15.828.2.6)
> pid 5860 tid 5624 cpid -1 node 0 sec 0 nsec 33580698 probe 6
> bytes 4
> 44040000 D...
>
> 54 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 5860 tid 5624 cpid -1 node 0 sec 0 nsec 33580713
>
> 55 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 37273380
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 56 exit DB2 oper system services sqloWaitIPCWaitPost cei (2.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 37273396
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 57 entry DB2 oper system services sqloWaitIPCWaitPost cei (1.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 37273443
>
> 58 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 37273459
>
> 59 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 41611912
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 60 exit DB2 oper system services sqloWaitIPCWaitPost cei (2.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 41611927
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 61 entry DB2 oper system services sqloWaitIPCWaitPost cei (1.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 41611976
>
> 62 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 41611993
>
> 63 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 45950440
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 64 exit DB2 oper system services sqloWaitIPCWaitPost cei (2.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 45950455
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 65 entry DB2 oper system services sqloWaitIPCWaitPost cei (1.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 45950505
>
> 66 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 45950521
>
> 67 exit DB2 oper system services sqloWaitInterrupt cei (2.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 50288969
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 68 exit DB2 oper system services sqloWaitIPCWaitPost cei (2.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 50288985
> rc = 0x870F00B9 = -2029059911 = SQLO_SEM_TIMEOUT
>
> 69 entry DB2 oper system services sqloWaitIPCWaitPost cei (1.3.15.557.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 50289033
>
> 70 entry DB2 oper system services sqloWaitInterrupt cei (1.3.15.560.2)
> pid 3212 tid 6328 cpid 868 node 0 sec 0 nsec 50289049
>
> 71 entry DB2 oper system services sqlo_init_GMT_timer_services cei[/color]
(1.3.15.593.2)[color=blue]
> pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52487611
>
> 72 exit DB2 oper system services sqlo_init_GMT_timer_services cei[/color]
(2.3.15.593.2)[color=blue]
> pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52487711
> rc = 0
>
> 73 entry DB2 trace services db2trc::main fnc (1.3.20.4.0)
> pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52488823
>
> 74 entry DB2 oper system services sqloPRegMachineOpen fnc (1.3.15.366.0)
> pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52490370
>
> 75 exit DB2 oper system services sqloPRegMachineOpen fnc (2.3.15.366.0)
> pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52490376
> rc = 0
>
> 76 entry DB2 oper system services sqloPRegRemoteValue fnc (1.3.15.372.0)
> pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52490381
>
> 77 data DB2 oper system services sqloPRegRemoteValue fnc (3.3.15.372.0.1)
> pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52490388 probe 1
> bytes 14
> 03000000 4442324D 5050FFFF FFFF ....DB2MPP....
>
> 78 data DB2 oper system services sqloPRegRemoteValue fnc (3.3.15.372.0.2)
> pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52490420 probe 2
> bytes 4
> 55000000 U...
>
> 79 data DB2 oper system services sqloPRegRemoteValue fnc (3.3.15.372.0.3)
> pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52490426 probe 3
> bytes 4
> 02000080 ....
>
> 88 data DB2 oper system services sqloPRegRemoteValue fnc (3.3.15.372.0.4)
> pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52491634 probe 4
> bytes 32
> 4442324C 4441505F 434C4945 4E545F50 DB2LDAP_CLIENT_P
> 524F5649 4445524D 6963726F 736F6674 ROVIDERMicrosoft
>
> 89 exit DB2 oper system services sqloPRegRemoteValue fnc (2.3.15.372.0)
> pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52491711
> rc = 0x870F0104 = -2029059836 = RC_ENV_NOT_FOUND
>
> 90 entry DB2 oper system services sqloPRegMachineClose fnc (1.3.15.365.0)
> pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52491715
>
> 91 data DB2 oper system services sqloPRegMachineClose fnc (3.3.15.365.0.1)
> pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52491716 probe 1
> bytes 4
> 02000080 ....
>
> 92 exit DB2 oper system services sqloPRegMachineClose fnc (2.3.15.365.0)
> pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52491721
> rc = 0[/color]
| 
