Register | Login

Published Articles

python file full path for windows

Posted by jaisrimakster (#63) 1825 days ago (Editorial)

Normal windows path from 'c:' will not work in python for windows.


Solution: In order to open a file in windows using python then we need to use c:/foldername/filename.


e.g.


f = open('c:/sri/text.py.txt', 'r+')


 


 


Is it possible to rename a column name?

Posted by jyothsnav 2033 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 2034 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 2267 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 2289 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 2239 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 2255 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


 


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.