Register | Login

Published Articles

Is it possible to rename a column name?

Posted by jyothsnav 2093 days ago (Editorial)

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>


 


How to find the last used date of an index

Posted by jyothsnav 2093 days ago (Editorial)

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='?'


 

Pligg configuring tinymce spellchecker

Posted by madeeswer 2326 days ago (Editorial)

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

MQ Error 2059 Message Queue Name not found

Posted by madeeswer 2349 days ago (Editorial)

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:


JBoss 4 or 5 what is HASingleton means

Posted by madeeswer 2299 days ago (Editorial)

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.


 


Running Jboss on port other than 8080

Posted by madeeswer 2315 days ago (Editorial)

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

Go to the following directory jboss-eap-5.1/jboss-as/server/default/deploy/jbossweb.sar

1. edit the server.xml

2. uncomment the line

      <Connector protocol="HTTP/1.1" SSLEnabled="true"
           port="8443" address="${jboss.bind.address}"
     &n


Start the servers after enabling the cluster.


In order to manage all the nodes in one console log on to the below mentioned link


 


http://www.yourwiz.com:8080/jmx-console/cluster/


 


Note: Chnage the www.yourwiz.com with your hostname


 



In order to deploy your application without specifying any context path, You need to delete Root.war and deploy your application in the same name at the same location.


Once the JBoss is up it will point to the Root.war. Since your application is deployed over there, Jboss will point your application without any context path.


In a clustered environment the war or ear files needs to be deployed in each and every instances.


Using the farm deployment, the *.ear or *.war files will be deployed only in the farm directory.


JBoss will automatically deploy the *.ear or *.war in the farm directory to all instance in the cluster.


 


Note: Farm deployment w

Sort News
Username:

Password:

Remember:
YourWiz.com, is a website that will allow everyone to share their knowledge, tip or information through community micro blogging.