DB2 Reorg and Run stats commands – life saver
Below are some life saver commands for DB2 admin for reorg and subsequent runstat – Reorganising tables:: This process helps in bringing together of widely...
A typical DB2 DB config
Below is a tuned DB config for a heavily loaded workflow application – [db2inst1@intranet db2inst1]$ db2 get db cfg for wf Database Configuration for Database...
A Typical IT Backup Policy and Backup procedure
Lets see how back up policy was important for a typical IT company and how did it implement the same. Background: As we progress in...
SPDT, SPST switches and fuses
Below are schematics of standard SPDT and SPST switches and fuses – ...
Wiring – Nose Plier
Another indispensible tool of an electrician –...
Electrical Soldering
Below schematic shows electrical soldering and equipments/materials used –...
Cut Plier – Wiring man’s freind
Schematic for mighty cut plier – Cut plier in almost indispensible for any wiring work. Pliers are used for gripping or holding small objects by...
Good Old Mallet!
Schematic for a good old mallet for wiring work –...
Wiring – Bends
Below are schematic of various bends used in electrical wiring –...
Junction boxes
Below are schematic of 3 and 4 way Junction boxes mentioned in the wiring articles –...
How to do Hospital Wiring?
Ok, here is a definitive article on how to set up Hosptial wiring – hands on. Read on – List of material needed – 1)...
Tunnel Wiring
Here is a definitive way to set up Tunnel Wiring by yourself – List of Materials needed 1) 230 V, 5A SPDT switches – 3...
Hands on Wiring – Godown Wiring
Ok, here is a definitive article on how to set up godown wiring – hands on. Read on – List of material needed – 1)...
Fuse is provided only in phase and never on nuetral, Why?
The main function of a fuse is to protect the electrical appliances connected in a building from damage by blowing out under faulty or high voltage...
Wiring Practice – Staircase wiring
A simple and practical way to set up staircase wiring is explained here. To operate a lamp from two different points by two switches at...
Sample Linux server (web centric) back up script in PERL
Below is a sample, detailed, PERL script for backing up your web centric Linux server. It includes ways to creating tgz of required areas, pushing...
Paper – Server Synchronization Technology for a Distributed server architecture (DSA)
Requirement: Company xyz has now decided to extend the current system as distributed server architecture, expanding over 46 locations. There will be a central server...
Sample Linux-Apache-PHP-DB2 installation instructions
Below is detailed customized installation for Linux-DB2 – 1. Suggested PC configuration for medium sized installations – P4 or above – 256 MB or above...
Sample (cheap) Web application architecture
A sample customized web application architecture is as shown below – As shown above, all the three tiers of the web server architecture, namely database...
Sample PL/SQL script for cleaning a detail table referring a master table
Have you ever had a need to write a PL/SQL snippet to clean a table. If you are in need, here is one below –...
Sample Perl program for cleaning database on a routine basis
Here is a samlpe Perl Program that gives you an outline on how to deal with cleaning DB on a routine basis (ofcourse scheudled via...
Comparing roles of a System Analyst and other IT professionals
A system analyst is a person of multifaceted role who has to deal with each and every function of a system. He is involved in...
Attributes of a Good System Analyst
A system analyst is a person who conducts a methodical study and evaluation of various aspects related to business to identify the desired objectives and...