![]() ![]() Over (order by storage_used desc ) as rank Show users by the total size of items they own (descending) with RANK() H dftactgrp( *no ) OPTION(*NODEBUGIO) ACTGRP(‘GETIP’)Įxec sql values(sysibm.CLIENT_IPADDR) into :MyIpAddress SQL to view transactions from a journal receiver (QAUDJRN) SV – System value changed, except for QAUDCTL severity 2 case.RP – Restoring adopted authority program.RJ – Restoring job description with user profile specified.PA – Program changed to adopt authority.LD – Link, unlink, or look up directory entry.GS – Socket description was given to another job.GR – Generic record, except for the Severity 4 case where function usage was checked and failed.SO – Server security user information actions Severity 6 Informational message.RZ – Change a primary group during restore.RO – Change of object owner during restore.PG – Change of an object’s primary group.CP – User profile changed, created, or restored.GR – Generic record, when function usage was checked and failed for a function name with a prefix of QIBM_DB_ Severity 5 Notice: A normal but significant condition.SV – System value when QAUDCTL is changed to *NONE Severity 4 Warning condition.The audit journal entries are assigned a SYSLOG_SEVERITY value in the following way: H dftactgrp( *no ) OPTION(*NODEBUGIO) ACTGRP(‘GETSTAMP’) *note - i know this is not the correct way to retrieve a timestamp - used for example only!!! Ifnull(CURRENT_NUMERIC_VALUE,0) as DecValue, Take some time and play with the SQL - Become famous Post new samples!!! List system values that contain “SEC” in the name. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |