Skip to main content

db2 one liners

Some very helpful one liners for db2.

If you are a fan like me to execute db2 commands within the Unix/AIX prompt, rather than going into DB2 inbuilt prompt then all commands run on the fly. Much powerful is Unix prompt as you can modify data in whichever way you want.


  • db2 list database directory;    #Lists all databases within the installation

  • db2 list node directory;

  • db2 "SELECT SCHEMANAME FROM SYSCAT.SCHEMATA";  #Shows all schema within the Database Instance

  • db2 set schema myschema01   # Setting schema before execution

  • db2 "LIST TABLES FOR SCHEMA myschema01" | more

  • db2 describe indexes for table <table_name> show detail | tr -s " "   # shows details about the table including primary key and indexes

  • db2 get snapshot for application agentid 228 | more

  • # db2 "force applicatioin (228) "   #Careful as it forces the session 228 out of DB2

  • db2pd -d myDB01 -wlocks

  • db2 export to C:\CSVFiles\OutputmyTable.csv of del select * from myTable   #For exporting data into CSV files.

  • db2 "VALUES CURRENT QUERY OPTIMIZATION"    # Checks the current optimisation level. Try changing and resetting it for your queries to run better

  • db2look -d<dbname> -z <schema> -t <table_name> -a -e -o output.ddl    #db2look utility is very useful in duplicating table and structures . Plenty of flags available including wildcards.

  • db2 "select * from syscat.tabconst"                # To check table constraints

  • db2 "select * from syscat.references"            # To check foreign key references of a table

  • syscat.keyclouse (contraint details),   syscat.checks (contraints at schema level)


Popular posts from this blog

Syslog Standards: A simple Comparison between RFC3164 & RFC5424

Syslog Standards: A simple Comparison between RFC3164 (old format) & RFC5424 (new format) Though syslog standards have been for quite long time, lot of people still doesn't understand the formats in detail. The original standard document is quite lengthy to read and purpose of this article is to explain with examples Some of things you might need to understand The RFC standards can be used in any syslog daemon (syslog-ng, rsyslog etc.) Always try to capture the data in these standards. Especially when you have log aggregation like Splunk or Elastic, these templates are built-in which makes your life simple. Syslog can work with both UDP & TCP  Link to the documents the original BSD format ( RFC3164 ) the “new” format ( RFC5424 ) RFC3164 (the old format) RFC3164 originated from combining multiple implementations (Year 2001)

Create your own Passport Photo using GIMP

This tutorial is for semi-techies who knows a bit of GIMP (image editing).   This tutorial is for UK style passport photo ( 45mm x 35 mm ) which is widely used in UK, Australia, New Zealand, India etc.  This is a quick and easy process and one can create Passport photos at home If you are non-technical, use this link   .  If you want to create United States (USA) Passport photo or Overseas Citizen of India (OCI) photo, please follow this link How to Make your own Passport Photo - Prerequisite GIMP - One of the best image editing tools and its completely Free USB stick or any memory device to store and take to nearby shop A quality Digital camera Local Shops where you can print. Normally it costs (£0.15 or 25 US cents) to print 8 photos Steps (Video Tutorial attached blow of this page) Ask one of your colleague to take a photo  of you with a light background. Further details of how to take a photo  yourself       Take multiple pictures so that you can choose from th

Elastic Beats on pfSense : Installation and configuration

Summary Though in many cases syslog is preferred to transport the pfSense logs to external system, Elastic beats provides quite a niche way to send the logs while modelling the data alongside. This makes it ready-made to send to ElasticSearch directly and get ready-made outcomes like SIEM, performance etc. Pre-reqs A build server (preferably Ubuntu or Fedora) with internet connectivity shell access to pfsense server Basic knowledge of Elastic Stack (filebeat.yml configurations etc) Ensure connectivity is allowed from pfsense machine to your Elastic Stack receiver Setup Summary Connectivity tests Install dependencies in build server (vagrant, virtualbox, gmake, go etc) Download Elastic Beats source Make elastic Beats package for FreeBSD Copy binary packages to pfsense server Configure Beats to send to destination Configure ElasticSearch to view the data Installation Steps Connectivity tests Logon to pfsense server via Shel