• Inline comments
  • # coment(s)
• Block comments
  • <IfDefine IgnoreBlockComment>
       coments(s)
    </IfDefine>

• List help
  • apachectl -h
• List server root directory (configs)
  • apachectl -t -D DUMP_RUN_CFG 2>/dev/null | grep 'ServerRoot' | awk -F'"' '{print $2}'
• List server error file
  • apachectl -t -D DUMP_RUN_CFG 2>/dev/null | grep 'Main Error' | awk -F'"' '{print $2}'
• Restart server
  • apachectl -k restart
  OR
  • /etc/init.d/apache2 restart

• Config file(s) are in <ServerRoot>/sites-available
• a2ensite <config file>
• a2dissite <config file>

• systemctl reload apache2
OR
• service apache2 reload

• List help
  • a2query -h
• List available sites
  • a2query -s

• List help
  • htpasswd
• Create a new file
  • htpasswd -c .htpasswd <user>
• Add user to file
  • htpasswd .htpasswd <user>
• Display line to added to file
  • htpasswd -n <user>

• AuthType Basic
  AuthName "Restricted Area"
  AuthUserFile .htpasswd
  Require valid-user
  

• /etc/logrotate.d/apache2

• /usr/sbin/apacheAccessLog.sh

1. Database Objects (16%)
2. Traditional Data Manipulation (30%)
3. SPL Programming (14%)
4. Core Concepts (24%)
   • Database
   • Data Integrity
   • Data Modeling
   • Configuration Management Database
5. Extensibility (16%)

• Enterprise Replication (ER)
• Shared Disk (SD) secondary
• High-Availability Data Replication (HDR)
• Remote Standalone (RS) secondary

• Create open source project
• Add filter

• Best Practices for Getting Started with Informix
• The basics of getting up and running with Informix by Tom Beebe
• Informix Best Practices for Configuring CPU, Memory and ONCONFIG settings
• Informix Best Practices - Disks and Database Space Layout by Art Kagel
• Informix Best Practices - Schema Design Tips by Art Kagel
• Informix Performance Tuning Webcast on March 12, 2013 by Art Kagel
• Informix Best Practice Informix Query Performance Tuning Basics by Mike Walker
• Informix Best Practices Webcast on Backup, Recovery, and High Availability Disaster Recovery (HDR)
• Informix Best Practices - Using the Sysmaster database to perform an Informix Server Heath Check
• Informix Best Practices - Introduction to Informix Enterprise Replication by Thomas Beebe
• New Informix Toys and Tools - NoSQL, Mongodb Support, Data Streams with Node-RED, by Tom Beebe
• Informix Best Practices Webcast on Informix Connection Manager

1. Filter for interactive SSH logins
   bash> grep sshd.\*Failed /var/log/auth.log | less

2. Filter for failed connections (i.e. no login attempted, could be a port scanner, etc.)
   bash> grep sshd.\*Did /var/log/auth.log | less

• Client config file
  • ~/.psqlrc


• Help
  • \?
  • \? [commands]
  • \? options
  • \? variables
  • \h [NAME]


• Pager...uses environment's "PAGER" variable
  • \pset pager off
  • \pset pager on


• Create table
  • CREATE TABLE tableName
    (
      id  smallserial not null primary key,
      dtCreated  timestamp not null,
      dtUpdated  timestamp,
      data  jsonb
    );
    


• Grants
  • GRANT SELECT, INSERT, UPDATE ON tableName TO userName;
    GRANT SELECT, UPDATE ON SEQUENCE tableName_id_seq TO userName;
    


• Insert
  • INSERT INTO tableName( dtcreated, data ) VALUES( now(), '{}' );


• Export table to CSV file
  • COPY tableName TO 'path/fileName.csv' CSV;


• Delete record(s)
  • DELETE FROM tableName WHERE id >= 1000000;


• Truncate table
  • TRUNCATE tableName;


• Import table from CSV file
  • COPY tableName FROM 'path/fileName.csv' WITH( FORMAT CSV );


• Alter sequence
  • ALTER SEQUENCE tableName_id_seq RESTART WITH 1;


• Drop table
  • DROP TABLE tableName;