SQL

SELECT A.data_queue_name, 
       A.data_queue_library,  
       A.current_messages, 
       B.current_messages, 
CASE 
    WHEN 
      A.current_messages = B.current_messages 
        THEN ' ' 
        ELSE '**diff**' 
END
FROM swtgemts1 A JOIN swtgemts2 B ON A.data_queue_name = B.data_queue_name;

SELECT host_name  
FROM QSYS2.SYSTEM_STATUS_INFO_BASIC;

SELECT * 
FROM QSYS2.SYSTEM_STATUS_INFO_BASIC ;

SELECT current_numeric_value  
FROM QSYS2.SYSTEM_VALUE_INFO
WHERE system_value_name = 'QMAXJOB' ;

SELECT BKHMC,
       BKHSYS,
       BKHCMD,
       BKHLIB,
       BKHSEQ,
       BKVOL,
       BKHSIZ,
       BKHDAT,
       BKHEXP
FROM QUSRBRM/Q1AHS                                                
WHERE BKDUPSTS = '1'                                               
ORDER BY BKVOL