Striim notes

 Hostname: tbstriimetl601.tmw.com

IP:              172.31.89.4


The following accounts all have the same pwd:


keystore / sys / admin user password is str11m


is it setup to autostart if server is bounced?    <-- need to ask this question on Monday


https://172.31.89.4:9081 

http://172.31.89.4:9080 


java DB also known as Derby

Since developers already have the DDL, no need to install iSpire.





jdbc:db2://host-name:50000/BLUDB

gk10ts19so


jdbc:as400://tuxlead.tmw.com/ORCA_PROD;libraries= ORCA_PROD LEDDTA LEDWRK LEDPGM QGPL;



jdbc:db2://<IP address>:<port>/<database name>

jdbc:as400://neon.tmw.com:8471


172.26.18.10 / neon

Port 8471


db2jcc_license_cu.jar   <-- IBM licensed jar file 


jdbc:as400://HOSTNAME:PORT;  


WRKSRVTBLE



tuxlead is the name of the host for the leads data

Port 8471


systemctl restart striim-node  to stop


jdbc:postgresql://<ip address>:<port>/<database name>

10.40.25.111 

jdbc:postgresql://pg-coupon-cpntest.gcp.tmw.com:5432/cpntest

sourceSchema.sourceTable,targetSchema.targetTable


CDEXDTA.OFRCDEA00

cpnadmin.offers



?sslmode=verify-full&sslrootcert=\\tmw.com\dfs\usrappsCA.crt&sslcert=db-client.crt&sslkey=db-client.pk8


jdbc:postgresql://pg-coupon-cpntest.gcp.tmw.com:5432/cpntest?sslmode=prefer&sslrootcert=/opt/striim/pg-coupon-cpntest_server-ca.pem&sslcert=/opt/striim/pg-coupon-cpntest_client-cert.pem&sslkey=/opt/striim/pg-coupon-cpntest_client-key.pem


jdbc:postgresql://pg-coupon-cpntest.gcp.tmw.com:5432/cpntest?sslmode=prefer&sslrootcert=O:\Users\GM15\keys\pg-coupon-cpntest_server-ca.pem&sslcert=O:\Users\GM15\keys\pg-coupon-cpntest_client-cert.pem&sslkey=O:\Users\GM15\keys\pg-coupon-cpntest_client-key.pem



openssl pkcs8 -topk8 -inform PEM -outform DER -in /opt/striim/pg-coupon-cpntest_client-key.pem -out /opt/striim/pg-coupon-cpntest_client-key.pk8 -nocrypt


5432/cpntest?enableSSL=true&requireSSL=true&verifyServerCertificate=true&sslrootcert=O:\Users\GM15\keys\pg-coupon-cpntest_server-ca.pem&sslcert=O:\Users\GM15\keys\pg-coupon-cpntest_client-cert.pem&sslkey=O:\Users\GM15\keys\pg-coupon-cpntest_client-key.pk8&1=1


 metadata: {

  "TableName" : "S107770E.CDEXDTA.OFRCDEA00",


Comments

Post a Comment

Popular posts from this blog

Oracle: To clean up WRI$_ADV_OBJECTS

 set linesize 200; select segment_name, segment_type, bytes from dba_segments where tablespace_name='SYSAUX' order by bytes asc; COL OCCUPANT_NAME FORMAT A30 SELECT OCCUPANT_NAME,SPACE_USAGE_KBYTES FROM V$SYSAUX_OCCUPANTS ORDER BY SPACE_USAGE_KBYTES DESC; COL SEGMENT_NAME FORMAT A30 COL OWNER FORMAT A10 COL TABLESPACE_NAME FORMAT A10 COL SEGMENT_TYPE FORMAT A15 SELECT * FROM (SELECT SEGMENT_NAME,OWNER,TABLESPACE_NAME,BYTES/1024/1024 "SIZE(MB)",SEGMENT_TYPE FROM DBA_SEGMENTS WHERE TABLESPACE_NAME='SYSAUX' ORDER BY BYTES DESC) WHERE ROWNUM<=10; 1.  automatic clean-up default 31 days           SELECT dbms_stats.get_stats_history_availability from Dual; 2. modify retention policy        exec  dbms_stats.alter_stats_history_retention (14); 3. a manual cleaning  exec dbms_stats.purge_stats (sysdate-14);   ALTER TABLE WRI$_ADV_OBJECTS MOVE; ALTER INDEX WRI$_ADV_OBJECTS_IDX_01 REBUILD; ALTER INDEX WRI$_ADV_OBJECTS_IDX_02 R...
Read more