Groovy DBA

 GRANT select ON trkt_data.TMW_GEOTAB_TRIP_HISTORY TO 'uc4jobs'@'%'; GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on *.* TO 'sammy'@'localhost' WITH GRANT OPTION; GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES on `tbi-cis-mysql-db`.* to 'gp102'@'%'; SHOW GRANTS FOR 'uc4jobs'@'%';

 SHOW GRANTS FOR 'uc4jobs'@'%';

 CREATE USER 'uc4jobs'@'%' IDENTIFIED BY 'zhen#bu_taiha0'; grant select on winwedstg.* to 'mv196'@'%'; GRANT execute on winweddev.* to 'pn46';

 /opt/lib/COBOLServer6 <- Visual COBOL v 6 installation  V1005645-01.zip  /opt/microfocus dbadmin / hr5809_Prod PS/PSHRPR0D ConnectID - people/People_123 Application Server Domain Connection Password : Passw0rd                    Domain Password : Passw0rd  PTWEBSERVER/People123 :/usr/opt/app/psoft/pt858/hrtestib_cfg/webserv/hrtestib/piabin>./PSCipher.sh People123 Encrypted text: {V2.1}2ZQk7UFyUA/C/rPSKa4p9iOhnHnRj9ouNQ== Weblogic - system/Passw0rd IB gateway  - administrator/People123 Keystore : Passw0rd Node Passwords PSFT_EP : PSAPPSRV / Zxt4wpTM Node Passwords PSFT_HR : PSAPPSRV / HR9PROD  HR9PR0DO Node Passwords PSFT_HR : PSAPPSRV / Zxt4wpTM   <-- changed 2021 Nov 15th ON HRPROD HR9PROD NOTHING ON FSTEST 8.56 LISTENING ON FSTEST.TMW.COM   HRTEST:  PSAPPSRV / Zxt4wpTM HRDBUG: PSAPPSRV / Zxt4wpTM FSPROD PSAPPSRV / Zxt4wpTM fstest PSAPPSRV / Zxt4wpTM hrdvlp  PSAPPSRV ...

 3 non - prod dev/test  one is performance stag / prod is one environment 4 DBs in prod HCL Enterprise Websphere 9.1.5 DB2 Enterprise 11.1.5 db2fenc1 - Fence user never accessed by a person. the DB2 engine use this db2inst1 - Instance user     on mrsdevdb2601 password is passw0rd db2admin -  DB2IADM1 -  /etc/group  DB2 Instance Aadmin #1  , db2admin member  DB2IADM2 -  8 characters or less  G! and Marc, after talking to Rajesh, this is what we agreed upon, but is subject to change.  J wcadmin is the database name in DB2  db2tst601.gcp.tmw.com à dev1/tst1, dev2/tst2, dev3/tst3-primary (4 CPU & 64 GB memory)  db2tst602.gcp.tmw.com à tst3-standby & reporting standby ( 2-4 CPU 16 GB Memory)   Below have not been built yet Db2stg601.gcp.tmw.com àstage (4 CPU 16 GB Memory) Db2prd601.gcp.tmw.com àprod-primary (4 CPU 32 GB Memory) Db2prd602.gcp.tmw.com àprod-standby and reporting standby (4 CPU 32 GB Memory)...