Ok, at the moment the server / client has not hung again, since I reverted back to an older version of the application software.
Am alarmed about the AIW, but we are totally reliant upon the software vendor as they created this database and software. It's not bespoke, but configurable.
The SQL I referrer to is the name of the module within the software we are using, whether it is using actual SQL is open to debate. So I leave that to one side for time being.
I will come back with a sample of good and bad times. Virtually no activity at the moment (8pm)
Below is database structure and database startup parameters our Proclaim database. At the very end is the client pf file.
Regards
Gregg
dbname.st
#
b E:\Proclaim\v3db\proclaimdb\proclaim.b1
#
d "Schema Area":6,32;1 E:\Proclaim\v3db\proclaimdb\proclaim.d1
#
d "General Data":7,128;8 E:\Proclaim\v3db\proclaimdb\proclaim_7.d1 f 100032
d "General Data":7,128;8 E:\Proclaim\v3db\proclaimdb\proclaim_7.d2 f 100032
d "General Data":7,128;8 E:\Proclaim\v3db\proclaimdb\proclaim_7.d3 f 100032
d "General Data":7,128;8 E:\Proclaim\v3db\proclaimdb\proclaim_7.d4
#
d "General Index":8,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_8.d1 f 50048
d "General Index":8,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_8.d2 f 50048
d "General Index":8,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_8.d3
#
d "Session Data":9,16;64 E:\Proclaim\v3db\proclaimdb\proclaim_9.d1 f 50048
d "Session Data":9,16;64 E:\Proclaim\v3db\proclaimdb\proclaim_9.d2
#
d "Session Index":10,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_10.d1 f 10048
d "Session Index":10,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_10.d2
#
d "High Activity Data":11,32;512 E:\Proclaim\v3db\proclaimdb\proclaim_11.d1 f 100032
d "High Activity Data":11,32;512 E:\Proclaim\v3db\proclaimdb\proclaim_11.d2 f 100032
d "High Activity Data":11,32;512 E:\Proclaim\v3db\proclaimdb\proclaim_11.d3
#
d "High Activity Index":12,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_12.d1 f 50048
d "High Activity Index":12,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_12.d2 f 50048
d "High Activity Index":12,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_12.d3
#
d "Field Dfn Data":13,64;64 E:\Proclaim\v3db\proclaimdb\proclaim_13.d1 f 10048
d "Field Dfn Data":13,64;64 E:\Proclaim\v3db\proclaimdb\proclaim_13.d2
#
d "Field Dfn Index":14,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_14.d1 f 10048
d "Field Dfn Index":14,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_14.d2
#
d "Names Data":15,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_15.d1 f 100032
d "Names Data":15,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_15.d2 f 100032
d "Names Data":15,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_15.d3 f 100032
d "Names Data":15,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_15.d4
#
d "Names Index":16,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_16.d1 f 50048
d "Names Index":16,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_16.d2 f 50048
d "Names Index":16,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_16.d3 f 50048
d "Names Index":16,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_16.d4
#
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d1 f 1000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d2 f 1000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d3 f 1000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d4 f 1000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d5 f 1000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d6 f 1000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d7 f 1000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d8 f 1000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d9 f 1000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d10 f 1000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d11 f 1912832
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d12 f 2000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d13 f 2000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d14 f 1925120
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d15 f 2000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d16 f 2000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d17 f 2000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d18 f 2000000
d "History Data":17,16;512 E:\Proclaim\v3db\proclaimdb\proclaim_17.d19
#
d "History Index":18,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_18.d1 f 500032
d "History Index":18,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_18.d2 f 500032
d "History Index":18,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_18.d3 f 500032
d "History Index":18,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_18.d4 f 500032
d "History Index":18,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_18.d5 f 500032
d "History Index":18,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_18.d6 f 500032
d "History Index":18,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_18.d7 f 500032
d "History Index":18,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_18.d8 f 500032
d "History Index":18,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_18.d9
#
d "Audit Data":19,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_19.d1 f 2000000
d "Audit Data":19,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_19.d2 f 1927168
d "Audit Data":19,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_19.d3 f 2000000
d "Audit Data":19,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_19.d4 f 2000000
d "Audit Data":19,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_19.d5 f 1968128
d "Audit Data":19,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_19.d6 f 2000000
d "Audit Data":19,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_19.d7 f 1923072
d "Audit Data":19,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_19.d8 f 2000000
d "Audit Data":19,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_19.d9 f 2000000
d "Audit Data":19,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_19.d10 f 2000000
d "Audit Data":19,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_19.d11 f 2000000
d "Audit Data":19,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_19.d12 f 2000000
d "Audit Data":19,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_19.d13 f 1908736
d "Audit Data":19,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_19.d14
#
d "Audit Index":20,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_20.d1 f 1000000
d "Audit Index":20,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_20.d2 f 1789248
d "Audit Index":20,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_20.d3 f 1917760
d "Audit Index":20,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_20.d4 f 2000000
d "Audit Index":20,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_20.d5
#
d "Case Data":21,128;512 E:\Proclaim\v3db\proclaimdb\proclaim_21.d1 f 500032
d "Case Data":21,128;512 E:\Proclaim\v3db\proclaimdb\proclaim_21.d2 f 500032
d "Case Data":21,128;512 E:\Proclaim\v3db\proclaimdb\proclaim_21.d3 f 500032
d "Case Data":21,128;512 E:\Proclaim\v3db\proclaimdb\proclaim_21.d4
#
d "Case Index":22,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_22.d1 f 100032
d "Case Index":22,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_22.d2 f 100032
d "Case Index":22,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_22.d3 f 100032
d "Case Index":22,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_22.d4
#
d "XRef Data":23,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_23.d1 f 500032
d "XRef Data":23,64;512 E:\Proclaim\v3db\proclaimdb\proclaim_23.d2
#
d "XRef Index":24,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_24.d1 f 100032
d "XRef Index":24,1;8 E:\Proclaim\v3db\proclaimdb\proclaim_24.d2
#
d "BLOB Data":25,32;1 E:\Proclaim\v3db\proclaimdb\proclaim_25.d1 f 100032
d "BLOB Data":25,32;1 E:\Proclaim\v3db\proclaimdb\proclaim_25.d2
startup parameters from the lg file
[2010/08/06@13:12:26.179+0100] P-7240 T-7692 I BROKER 0: (333) Multi-user session begin.
[2010/08/06@13:12:26.195+0100] P-7240 T-7692 I BROKER 0: (5326) Begin Physical Redo Phase at 23552 .
[2010/08/06@13:12:26.570+0100] P-7240 T-7692 I BROKER 0: (7161) Physical Redo Phase Completed at blk 24744 off 4869 upd 590.
[2010/08/06@13:12:26.570+0100] P-7240 T-7692 I BROKER 0: (13547) At end of Physical redo, transaction table size is 512.
[2010/08/06@13:12:26.711+0100] P-7240 T-7692 I BROKER 0: (452) Login by Administrator on CON:.
[2010/08/06@13:12:26.726+0100] P-7240 T-7692 I BROKER 0: (5644) Started for 11001 using TCP IPV4 address 0.0.0.0, pid 7240.
[2010/08/06@13:12:26.726+0100] P-7240 T-7692 I BROKER 0: (8836) Connecting to Admin Server on port 7841.
[2010/08/06@13:12:26.726+0100] P-7240 T-7692 I BROKER 0: (14262) Successfully connected to AdminServer on port 7841 using TCP/IP IPV4 address 10.11.1.21.
[2010/08/06@13:12:26.726+0100] P-7240 T-7692 I BROKER 0: (8846) Registered with Admin Server.
[2010/08/06@13:12:26.726+0100] P-7240 T-7692 I BROKER 0: (4234) Progress OpenEdge Release 10.2A build 1390 SP03 on WINNT .
[2010/08/06@13:12:26.726+0100] P-7240 T-7692 I BROKER 0: (4281) Server started by Administrator on CON:.
[2010/08/06@13:12:26.726+0100] P-7240 T-7692 I BROKER 0: (6574) Started using pid: 7240.
[2010/08/06@13:12:26.726+0100] P-7240 T-7692 I BROKER 0: (4235) Physical Database Name (-db): E:\Proclaim\v3db\proclaimdb\proclaim.
[2010/08/06@13:12:26.726+0100] P-7240 T-7692 I BROKER 0: (4236) Database Type (-dt): PROGRESS.
[2010/08/06@13:12:26.726+0100] P-7240 T-7692 I BROKER 0: (4237) Force Access (-F): Not Enabled.
[2010/08/06@13:12:26.726+0100] P-7240 T-7692 I BROKER 0: (4238) Direct I/O (-directio): Not Enabled.
[2010/08/06@13:12:26.726+0100] P-7240 T-7692 I BROKER 0: (-----) LRU mechanism enabled.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4239) Number of Database Buffers (-B): 400000.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (9422) Maximum private buffers per user (-Bpmax): 64.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4240) Excess Shared Memory Size (-Mxs): 133.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (10014) The shared memory segment is not locked in memory.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4241) Current Size of Lock Table (-L): 150016.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (13953) Maximum Area Number (-maxArea): 32000.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4242) Hash Table Entries (-hash): 137743.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4243) Current Spin Lock Tries (-spin): 80000.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (6526) Number of Semaphore Sets (-semsets): 3.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (13924) Maximum Shared Memory Segment Size (-shmsegsize) 2048 Mb.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4244) Crash Recovery (-i): Enabled.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (6573) Database Blocksize (-blocksize): 4096.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4245) Delay of Before-Image Flush (-Mf): 32000.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4247) Before-Image File I/O (-r -R): Reliable.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4249) Before-Image Truncate Interval (-G): 0.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4250) Before-Image Cluster Size: 16777216.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4251) Before-Image Block Size: 16384.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4252) Number of Before-Image Buffers (-bibufs): 64.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (-----) Record free chain search depth factor 5 (-recspacesearchdepth)
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (9238) BI File Threshold size (-bithold): 0.0 Bytes.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (6552) BI File Threshold Stall (-bistall): Disabled.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4254) After-Image Stall (-aistall): Not Enabled.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4255) After-Image Block Size: 8192.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4256) Number of After-Image Buffers (-aibufs): 64.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (8527) Storage object cache size (-omsize): 1024
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4257) Maximum Number of Clients Per Server (-Ma): 5.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4258) Maximum Number of Servers (-Mn): 101.
[2010/08/06@13:12:26.742+0100] P-7240 T-7692 I BROKER 0: (4259) Minimum Clients Per Server (-Mi): 1.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (4260) Maximum Number of Users (-n): 301.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (4261) Host Name (-H): GHNSVR-17.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (4262) Service Name (-S): 11001.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (14268) TCP/IP Version (-ipver) : IPV4
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (4263) Network Type (-N): TCP.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (4264) Character Set (-cpinternal): ISO8859-1.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (4282) Parameter File: Not Enabled.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (5647) Maximum Servers Per Broker (-Mpb): 100.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (5648) Minimum Port for Auto Servers (-minport): 11500.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (5649) Maximum Port for Auto Servers (-maxport): 11900.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (8865) This broker supports both 4GL and SQL server groups.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (9426) Large database file access has been enabled.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (9336) Created shared memory with segment_id: 12713984
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (12813) Allowed index cursors (-c): 1204.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (12814) Group delay (-groupdelay): 10.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (12815) Lock table hash table size (-lkhash): 25621
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (12816) Maxport (-maxport): 11900
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (12817) Minport (-minport): 11500
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (12818) Message Buffer Size (-Mm): 4096
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (12820) Maximum Servers per Broker (-Mpb): 100
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (12821) Use muxlatches (-mux): 1
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (12823) Semaphore Sets (-semsets): 3
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (13870) Database Service Manager - IPC Queue Size (-pica) : 64.0 KBytes.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (13896) TXE Commit lock skip limit (-TXESkipLimit): 10000.
[2010/08/06@13:12:26.757+0100] P-7240 T-7692 I BROKER 0: (10471) Database connections have been enabled.
Client pf file, it launches multiple databases but it Proclaim that we have the issue with:
# database.pf - startup parameters for smartpath development session
-mmax 65000
-nb 255
-l 768
-Bt 4096
-Mm 4096
-s 2048
-db proclaim
-ld proclaim
-H GHNSVR-17
-S 11001
-N tcp
-db dsp
-ld sp
-H GHNSVR-17
-S 12001
-N tcp
-db proacc
-ld proacc
-H GHNSVR-17
-S 13001
-N tcp
-db dyndb
-ld dynschema
-H GHNSVR-17
-S 15001
-N tcp
-d dmy
-T c:\temp
# -mmax 16768
-Bt 8192