Show active ingres sessions

From PTAGISWiki

Ingres allows viewing the active task list through the iimonitor tool, but this tool can be clumsy and difficult to read, especially when you are urgently trying to determine which task is consuming too many resources.

A perl script was developed to make it easier to get the information we need out of iimonitor quickly.

The script merges the output of iimonitor show sessions and iimonitor format sessions and presents a single tabular report.

The script must be run as root on blueback.

A sample run of the script looks like this:

bash-3.00$ ./DBA_listActiveSessions.pl 
Session 1DC8E100:203845 User: websr     Query:  State: CS_INTERRUPT_MASK,CS_NOXACT_MASK Client host: rufus.psmfc.org    
Session 1D3FE100:221128 User: marvin    Query:  State: CS_INTERRUPT_MASK        Client host: blueback   
Session 1DDB0100:197488 User: websr     Query:  State: CS_INTERRUPT_MASK        Client host: reedi.psmfc.org    
Session 1E387100:183921 User: websr     Query:  State: CS_INTERRUPT_MASK        Client host: reedi.psmfc.org    
Session 1DB70100:221341 User:   Query:  State: CS_INTERRUPT_MASK        Client host:    
Session 1DBCA100:205099 User: websr     Query:  State: CS_INTERRUPT_MASK,CS_NOXACT_MASK Client host: reedi.psmfc.org    
Session 1E3F23C0:183920 User: websr     Query:  State: CS_INTERRUPT_MASK        Client host: reedi.psmfc.org    
Session 1DC9DCC0:203846 User: websr     Query:  State: CS_INTERRUPT_MASK,CS_NOXACT_MASK Client host: rufus.psmfc.org    
Session 1DD0E100:204290 User: websr     Query:  State: CS_INTERRUPT_MASK,CS_NOXACT_MASK Client host: rufus.psmfc.org    
Session 1DBDABC0:210048 User: websr     Query:  State: CS_INTERRUPT_MASK,CS_NOXACT_MASK Client host: rufus.psmfc.org    
Session 33672100:203231 User: websr     Query:  State: CS_INTERRUPT_MASK,CS_NOXACT_MASK Client host: reedi.psmfc.org    
Session 1F66B180:203444 User: websr     Query:  State: CS_INTERRUPT_MASK,CS_NOXACT_MASK Client host: reedi.psmfc.org    
Session 3361C100:203339 User: websr     Query:  State: CS_INTERRUPT_MASK,CS_NOXACT_MASK Client host: reedi.psmfc.org    
Session 2AD26E20:183919 User: websr     Query:  State: CS_INTERRUPT_MASK        Client host: reedi.psmfc.org    
Session 33627100:187759 User: websr     Query:  State: CS_INTERRUPT_MASK        Client host: reedi.psmfc.org    
Session 1DDBD3E0:197607 User: websr     Query:  State: CS_INTERRUPT_MASK,CS_NOXACT_MASK Client host: reedi.psmfc.org    
Session 1D47E100:194776 User: websr     Query:  State: CS_INTERRUPT_MASK        Client host: reedi.psmfc.org    
Session 1E37C100:203443 User: websr     Query:  State: CS_INTERRUPT_MASK,CS_NOXACT_MASK Client host: reedi.psmfc.org    
Session 1DD1D2C0:203844 User: websr     Query:  State: CS_INTERRUPT_MASK,CS_NOXACT_MASK Client host: rufus.psmfc.org    
Session 1DB7B100:221374 User:   Query:  State:  Client host: