IBMi

By kimot, 24 December, 2022

SQL - compare 2 user profiles to assigned AUTL 

SELECT A.AUTL as user1, B.AUTL as user2
FROM (SELECT autl
      FROM QSYS2.AUTHORIZATION_LIST_USER_INFO
      WHERE user_name = 'profile_1')  A
FULL OUTER JOIN (SELECT autl
      FROM QSYS2.AUTHORIZATION_LIST_USER_INFO
      WHERE user_name = 'profile_2')  B 
ON A.AUTL = B.AUTL;
By kimot, 24 December, 2022

Show information about *FILE or SQL View (QSYS2.SYSTABLES) 

SELECT table_name, system_table_name, table_schema, table_type, table_owner, column_count, row_length, table_text, long_comment, file_type
FROM QSYS2.SYSTABLES
WHERE table_name = 'USER_INFO' AND table_schema='QSYS2'
By kimot, 24 December, 2022

MOVSQLFBQ - moves spoll files between output queues 

/******************************************************************************/     
/* Program moves spool files between output queues                            */     
/* Parameters: old_lib/old_queue/user/filename/user_data/new_lib/new_queue    */     
/* V 1.0  cTomik 02/2021                                                      */     
/* SQL QSYS2.OUTPUT_QUEUE_ENTRIES view used                                   */     
/******************************************************************************/
By kimot, 23 December, 2022

End Vision Solution (MIMIX) web service

You can check if server is running by command


WRKACTJOB SBS(QHTTPSVR) JOB(VSISVR)

               Current                                        
Subsystem/Job  User        Type  CPU %  Function        Status
  VSISVR       QTMHHTTP    BCH      .0  PGM-VSPSVR       TIMW 
  VSISVR       QTMHHTTP    BCI      .4  JVM-org.apache   SELW

Command VSI001LIB/ENDVSISVR will End Assure UI Server

IBMi