"Garfield Lewis" <ga*****@SPAM-NO-MOREca.ibm.com> wrote in message news:<ca**********@hanover.torolab.ibm.com>...
Hi JS,
Can you get a trace from one of the <HOSTNAME> machines?
--
Garfield A. Lewis
DB2 UDB Development,
IBM Canada Laboratory
"JS" <fy***@hotmail.com> wrote in message
news:e9**************************@posting.google.c om... 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 node:
<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?
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 (1.3.128.23.2)
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 (2.3.128.23.2)
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 (1.3.15.593.2)
pid 1804 tid 3236 cpid -1 node -1 sec 0 nsec 52487611
72 exit DB2 oper system services sqlo_init_GMT_timer_services cei (2.3.15.593.2)
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
