Skip to main content

db2 one liners

By df
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)


Labels:

Popular posts from this blog

Create your own Passport Photo using GIMP

By df
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
Read more

Syslog Standards: A simple Comparison between RFC3164 & RFC5424

By
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)
Read more

VS Code & Portable GIT shell integration in Windows

By df
Visual Studio Code & GIT Portable shell Integration Summary Many of your corporate laptop cannot install programs and it is quite good to have them as portable executables. Here we find a way to have Portable VS Code and Portable GIT and integrate the GIT shell into VS Code Pre-Reqs VS Code (Install version or Portable ) GIT portable Steps Create a directory in your Windows device (eg:  C:\installables\ ) Unpack GIT portable into the above directory (eg it becomes: C:\installables\PortableGit ) Now unpack Visual Studio (VS) Code and run it. The default shell would be windows based Update User or Workspace settings of VS Code (ShortCut is:  Control+Shift+p ) Update the settings with following setting { "workbench.colorTheme": "Default Dark+", "git.ignoreMissingGitWarning": true, "git.enabled": true, "git.path": "C:\\installables\\PortableGit\\bin\\git.exe", "terminal.integrated.shell.windows"
Read more