Published Articles

Perl Programming workshop based training in chennai on May 19th and May 20th.

http://www.ignitemindz.com/index.php/perl-programming-workshop-based-training-in-chennai-on-may-19-and-may-20

Yes it is possible to rename a column name in DB2 V9.7 version online.

Exception: If the column to be renamed is a part of primary key, we should drop the primary key, rename the column and then recreate the primary key

Command:

ALTER TABLE <TABNAME> RENAME COLUMN <OLDNAME> TO <NEWNAME>

In earlier versions of DB2, we donot have the facility to find the last used date of an index. But in V9.7, this feature is available which will help us in analysing the real usage of that index and whether it is required.

Command:

SELECT LASTUSED FROM SYSCAT.INDEXES WHERE INDNAME='?'

OR

SELECT INDNAME,LASTUSED FROM SYSCAT.INDEXES WHERE TABNAME='?'

In many scenarios Tiny Mce spell checker will not work when you add tiny mce to pligg.

To solve this issue, download the latest version of tinymce spell checker.

unzip the download and copy the folder under plug-ins folder of tinymce.

In Tinymce.init - remove the iespell from plugins and change it as spellchecker.

e.g.

tinyMCE.init({
  &nb

There are few possiblities for Error 2059.

2059 means the queue manager is down or the queue name your trying to use is not available.

Copy server/all to server/node1 by entering the following:

There will be lot of business cases to be executed for an application. Consider a scenario that you want to execute on business case only once across the cluster.

In this scenario if one node picks up the task then the other node should not pick the same task. so use HA singleton for this.

We can run Jboss on port other than the default port 8080.

In order to do this we have to change the port entry in server.xml

$Jboss_Home->default->deploy->jboss-web.deployer->server.xml

vi server.xml

change the port number from 8080 to what ever you wish.

This will allow the Jboss to start in your