Groovy DBA

to see what is in the buffer: SHOW ENGINE INNODB STATUS; Find the thread ID (ID column) SHOW FULL PROCESSLIST; To kill the process, run the command kill ID; Other helpful SQLs: show variables like 'innodb_lock_wait_timeout'; SHOW GLOBAL VARIABLES LIKE 'innodb_rollback_on_timeout';  SHOW GLOBAL STATUS LIKE 'com_rollback'; SHOW ENGINE INNODB STATUS; SHOW FULL PROCESSLIST; SELECT * FROM performance_schema.data_lock_waits; SELECT * FROM performance_schema.events_statements_history WHERE `THREAD_ID` = 1254; SELECT min(`THREAD_ID`), max(`THREAD_ID`) FROM performance_schema.events_statements_history;  SELECT @@performance_schema_events_statements_history_size;   SELECT @@performance_schema_events_statements_history_long_size;   UPDATE performance_schema.setup_consumers SET enabled = 'YES' WHERE name = 'events_statements_history_long';   SELECT count(`THREAD_ID`) FROM performance_schema.events_statements_history_long;   SELECT * FROM performance_schema.d...

 In appserv log, APPSRV_0617.LOG:  PeopleSoft ID and Password authentication failed. Invalid password for user PTWEBSERVER@pshrtstws601. (1) Update password in PIA for PTWEBSERVER PTWEBSERVER/People123 (2) update password in configuration.properties file with encrypted password for field  WebPassword  :- :/usr/opt/app/psoft/pt858/hrtestib_cfg/webserv/hrtestib/piabin>./PSCipher.sh People123 Encrypted text: {V2.1}2ZQk7UFyUA/C/rPSKa4p9iOhnHnRj9ouNQ== ----- From Oracle Support:- If you can't logon to PIA to change the password for the PTWEBSERVER account do the steps below. If you can logon you can change the password in security and then proceed to step 4.  1. Stop all PIA and application server domains. The example below is using PTWEBSERVER as the password. 2. Login to Datamover in Bootstrap mode. 3. Execute: UPDATE PSOPRDEFN SET OPERPSWD = ' ', PTOPERPSWDV2='<password>', ENCRYPTED=0, ACCTLOCK = 0 WHERE OPRID='PTWEBSERVER'; 4. Go to a command prompt ...

  SELECT S . relname , T . relname AS table_name FROM pg_class S LEFT JOIN pg_depend D ON ( S . oid = D . objid ) LEFT JOIN pg_class T ON ( D . refobjid = T . oid ) LEFT JOIN pg_namespace N ON ( N . oid = S . relnamespace ) WHERE S . relkind = 'S' ;

  SELECT relname FROM pg_class C JOIN pg_namespace N ON ( N . oid = C . relnamespace ) WHERE C . relkind = 'S' AND N . nspname = 'your_schema' ;

 select TOOLSREL from sysadm.PSSTATUS; If you are a regular PIA user, then the quickest way probably is in a PIA session via  Ctrl-J  key combination: Sign-in into a PIA client session in a web browser. Navigate to any non-search PIA page (does not matter which, Tools or application). Press key combination  Ctrl-J  (press key  Ctrl  and while keeping it pressed, press key for letter  J ) If any browser pop-up window opens (like Downloads History in Firefox), just discard (close) it. On the PIA information page that opens, locate and copy your exact Tools version, like: Or if you use App Designer or Data Mover utility more often than PIA, do this: Login into your PeopleSoft Windows Workstation Launch the  Application Designer  or  Data Mover  utility. See what exact PeopleTools version it displays on the Signon dialog, like Or if you have access to the application server box, via file  peopletools.properties , property...