Groovy DBA

  SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ; col parameter format a50 col VALUE format a40 set linesize 200 select * from NLS_DATABASE_PARAMETERS; 

select list_duplicate_field_names from table_name group by (list out fields) having count(*)>1;

(1) log in as the instance owner (2) connect to the database (3) run the command below to look for severe or critical entries in the 30min window  db2diag -l "Severe,Critical" -t 2023-03-08-12.00.04:2023-03-08-12.30.04 | more OR  To look for just severe entries db2diag -l "Severe" -t 2023-03-08-12.00.04:2023-03-08-12.30.04 | more Or to look for just critical entries db2diag -l "Critical" -t 2023-03-08-12.00.04:2023-03-08-12.30.04 | more