Admin utilities

Listlogs

This function takes two integers--a session ID and a dataslice ID. The session ID can be either a valid session ID or the value “-1” to indicate all sessions. The dataslice ID is ignored by the listlogs function, but is used to control the locus of execution (host or SPU, as well as dataslice). For example:

SELECT * FROM TABLE WITH FINAL(listlogs(-1,0));

The function returns the dataslice ID (DSID), the type of the log file (TYPE), the modified timestamp (MODIFIED), and the log file name (FILENAME). Table 1 shows sample output, formatted for easier reading.

Viewlog

This function takes two arguments--the file name and the dataslice ID.

SELECT * FROM TABLE WITH FINAL(viewlog('/u01/home/nz/workspaces/usr-bdrosen-
tfunc/main/tmp/nzae-IDENTIFIER-0-13894-14302-16934.txt_parent.txt',0));

The function returns the dataslice ID (DSID), the log file name (FILENAME), the slice of the file (SLICE), and the line of text (DATA). Table 2 shows the output, formatted for easier reading.

Cleanlogs

This function takes two arguments--the session ID and the dataslice ID. It returns the dataslice ID and text detailing how many files were deleted (with a limit of 20 rows of output).

SELECT * FROM TABLE WITH FINAL(cleanlogs(16934,0)) LIMIT 20;
DSID                                 TXT
0                                    Deleted 229 log files
(1 row)