Using Admin Utilities

Log Files

Complete documentation concerning log file management can be found in the section Working with Log Files.

Abort Hung

This utility can be used to abort a hung AE. An AE may hang if there are bugs in the AE code.

Abort Hung takes two integers--a session ID and a dataslice ID. The session ID can be either a valid session ID or “-1” for all sessions. The dataslice ID is ignored by the aborthung function, but is used to control the locus of execution (host or SPU, as well as dataslice).

This function returns the dataslice ID and the text indicating what was aborted.

SELECT * FROM TABLE(aborthung(-1,0));
DSID |               TXT
——+————————–
0 | Aborted 1 hung processes
(1 row)
SELECT * FROM TABLE(aborthung(-1,0));
DSID | TXT
——+—–
(0 rows)

For all of the utilities, the dataslice ID parameter controls whether it is run on the host or the SPU. To run it on the SPU:

SELECT * FROM _v_dual_dslice, TABLE WITH FINAL(aborthung(-1,dsid));

This command correlates the table function with the _v_dual_dslice table, which exists on the SPU, causing the table function to be run on the SPU.