Groovy DBA

 SELECT current_database(), nspname AS schemaname, tblname, idxname, bs*(relpages)::bigint AS real_size,   bs*(relpages-est_pages)::bigint AS extra_size,   100 * (relpages-est_pages)::float / relpages AS extra_pct,   fillfactor,   CASE WHEN relpages > est_pages_ff     THEN bs*(relpages-est_pages_ff)     ELSE 0   END AS bloat_size,   100 * (relpages-est_pages_ff)::float / relpages AS bloat_pct,   is_na   -- , 100-(pst).avg_leaf_density AS pst_avg_bloat, est_pages, index_tuple_hdr_bm, maxalign, pagehdr, nulldatawidth, nulldatahdrwidth, reltuples, relpages -- (DEBUG INFO) FROM (   SELECT coalesce(1 +          ceil(reltuples/floor((bs-pageopqdata-pagehdr)/(4+nulldatahdrwidth)::float)), 0 -- ItemIdData size + computed avg size of a tuple (nulldatahdrwidth)       ) AS est_pages,       coalesce(1 +  ...

 

  Create Client pkcs#12   openssl pkcs12 -export -in /etc/mysql/certs/client-cert.pem -inkey /etc/mysql/certs/client-key.pem -certfile /etc/mysql/certs/ca-cert.pem -out /tmp/client-keystore.p12 -name mysqlclient -passout pass:changeit   Create Trusstore PKCS keytool -import -trustcacerts -file /etc/mysql/certs/ca-cert.pem -alias mysqlserver -keystore /tmp/mysql-truststore.p12 -storetype PKCS12 -storepass changeit -noprompt   JDBC URL:   jdbc:mysql://mysql-pmmdevdb601.gcp.tmw.com:3306/pmmdvlp?useSSL=true&requireSSL=true&verifyServerCertificate=true&clientCertificateKeyStoreUrl=file:/tmp/client-keystore.p12&clientCertificateKeyStorePassword=changeit&clientCertificateKeyStoreType=PKCS12&trustCertificateKeyStoreUrl=file:/tmp/mysql-truststore.p12&trustCertificateKeyStorePassword=changeit&trustCertificateKeyStoreType=PKCS12   jdbc:mysql://mysql-pmmdevdb601.gcp.tmw.com:3306/pmmdvlp?useSSL=true&requireSSL=true&verifyServerCer...

 [root@pshrps601 ~]# chage -l psoft Last password change                                    : May 24, 2010 Password expires                                        : never Password inactive                                       : never Account expires                                         : never Minimum number of days between password change          : -1 Maximum number of days between password change          : -1 Number of days of warning before password expires       : -1 [root@pshrps601 ~]#

 db2 list history backup since 20251022 for db wcdev2

  SELECT nmsp_parent.nspname AS parent_schema, parent.relname AS parent, nmsp_child.nspname AS child_schema, child.relname AS child FROM pg_inherits JOIN pg_class parent ON pg_inherits.inhparent = parent.oid JOIN pg_class child ON pg_inherits.inhrelid = child.oid JOIN pg_namespace nmsp_parent ON nmsp_parent.oid = parent.relnamespace JOIN pg_namespace nmsp_child ON nmsp_child.oid = child.relnamespace WHERE parent.relname = 'parent_table_name' ;