Tuesday, February 24, 2015

DB2 BLOB

DB2 BLOB Knowledge centre link

From the IBM Knowledge centre guide :

BLOB or BINARY LARGE OBJECT(integer [K | M | G])
For a binary large object string of the specified maximum length in bytes.
The length may be in the range of 1 byte to 2 147 483 647 bytes.
If integer by itself is specified, that is the maximum length.
If integer K (in either upper- or lowercase) is specified, the maximum length is 1 024 times integer. The maximum value for integer is 2 097 152.
If integer M is specified, the maximum length is 1 048 576 times integer. The maximum value for integer is 2 048.
If integer G is specified, the maximum length is 1 073 741 824 times integer. The maximum value for integer is 2.
If a multiple of K, M or G that calculates out to 2 147 483 648 is specified, the actual value used is 2 147 483 647 (or 2 gigabytes minus 1 byte), which is the maximum length for a LOB column.
If the length specification is omitted, a length of 1 048 576 (1 megabyte) is assumed.
Any number of spaces is allowed between the integer and K, M, or G, and a space is not required. For example, all of the following are valid:
   BLOB(50K)    BLOB(50 K)    BLOB (50   K)

Sunday, December 7, 2014

Identify and kill inactive flowcharts

Solaris Tunable Parameters

Memory Analyser Tools

Class Loader Debugging for Memory leak

Effective java debugging with Eclipse

Friday, December 5, 2014

Thread Dump Analysis

1)  Thread Dump Analysis for IBM JVM - Part 1

I came across a good video which explains how to make sense of the java core text file.
Give it a watch or two and it will make sense.
Thread Dump Analysis for IBM JVM - Part 1

2) How to Analyze Java Thread Dumps - DZone article
Below is a pretty detailed article on analysing thread dumps - the HOW Tos..

3) Thread dump analysis - javaeesupportpatterns
Quite enjoy the coverage of this article. Take a look  here.

4) Webcast replay: Analysis of hangs, deadlocks, and resource contention or monitor bottlenecks using IBM Thread and Monitor Dump Analyzer for Java Technology .
Find the link here.

5) Diagnose java resource starvation

6) Using a java dump

7)How to diagnose starvation issue using IBM Thread and Monitor Dump Analyzer for Java Technology

Take a look at the ppt here.