I2DB Database admin documentation

General

• Frequent DBA Tasks (updating currently)
• DBA cheat sheet

MARS

MDCLone

• Stopping and Starting MDClone Cloudera Service

REDCap

RDC

• Using git with RIS Compute Job
• PostgreSQL Bloat Reporting
• PostgreSQL Storage Reporting

SPARC

SOURCE

Cleanup

General

• Functions available when using RIS compute Lsub job for postgres
• Aging PostgreSQL Users
• Copying Files to Azure VM with az CLI

MDClone

• WORKING HERE: Extracting Passwords from Cloudera Config
• Cloudera Backups
• Monthly MDClone Talend OMOP Extract

REDCap

• Helpful Queries
• Azure Data-in Replication Setup

RDC

• Update nifi databricks API key
• Setting Up for Running RIS Compute Jobs
• Functions and Environment Available to RIS Compute Job
• RDC ETL control and Nifi
• Requesting databricks service principals

TODOs

General

• Server List
• Devops Deployment Template
• how rest the postgres password on real VM or Server

MARs

• Mars Support Documentation

MDClone

• Impala Sizing Report
• MDClone Monthly Extract

REDCAP

• REDCap Database Upgrade

SPARC

• SPARC automation Support

RDC

• Production to Development Resync for OMOP Database

Source

• SOURCE Support Document

Issues

• COMPLETE: source managing admin users

Link to Devops Repo:

https://dev.azure.com/wustl-i2/RDC/_git/db-support-documentation