SQL1042C - hostname changed on db2 server windows/unix

1.       Run the following commands:

·         db2admin stop

·         db2stop

2.       The same hostname will be repeated twice on a single line in the db2nodes.cfg file. 

*Note that, only DB2 ESE has a db2nodes.cfg file. If you are running other editions (WorkGroup Server, or Personal Edition) then you can skip this step and go to 3rd step.

File Location:

UNIX/Linux:
db2 instance home directory/sqllib/db2nodes.cfg

All Windows flavors running DB2 v8 and v9.1:
Program Files\IBM\SQLLIB\DB2\db2nodes.cfg 

Windows XP and 2003 running DB2 v9.5:
Documents and Settings\All Users\Application Data\IBM\DB2\DB2COPY\DB2\db2nodes.cfg

NOTE: Application Data is a hidden folder

Windows Vista and later operating systems: ProgramData\IBM\DB2\DB2COPY\DB2\db2nodes.cfg

3.       Use the db2extsec command to update the authorities for the installation-defined groups DB2ADMNS and DB2USERS with new hostname. 

                           

          For example the new hostname = 'newhostname'

                           

     Run the following command:

•   db2extsec -a newhostname\DB2ADMNS -u newhostname\DB2USERS

4.       Update the DB2 registry variables using db2set command. Run the following commands:

·         db2set db2accountname=newhostname\db2admin

·         db2set db2instowner=newhostname

·         db2set db2system=newhostname

Suggestions are always welcome..!  Without signing also you can send your comments.

My laptop starts automatically from hibernation and drains battery windows 7

My laptop starts automatically from hibernation and drains battery - windows 7

1. Open Device Manager by clicking the Start button
2. Click on Control Panel, here click on System and Security
3. Under System, click on Device Manager.‌ If you're prompted for an administrator password or confirmation, type the password or provide confirmation.
4. In the list of hardware categories, find the device that you want to prevent from waking your computer, and then double-click the device name.
5. Click the Power Management tab and then clear Allow this device to wake the computer check box.
6. Click OK.

For example I got issue from wifi hardware. Below you can see image for better info.

Suggestions are always welcome..!  Without signing also you can send your comments.

How to use SCP command ?

Copying files using SCP command:

SCP ~ Secure Copy, which is used for copying files between local to remote or remote to local or remote to remote. These transfers are based on SSH ~ Secure Shell protocol

SCP options:

-p     preserves the modification and access times, as well as the permissions of the source-file in the destination-file

-P     port, specify only if it is other than the default port 22

-q     does not display the progress bar

-r      recursive, copies the contents of the source-file (directory in this case) recursively

-v     displays debugging messages

Examples:

Copying file to host:

scp /tmp/file_name user@host:/directory/TargetFile

 scp *.log user@remote.server.com:/home/user/

That is going to copy all files with .log extension to the folder /home/user in the remote.server.com host

Copying file from host:

scp user@host:directory/file_name TargetLocation or Folder

scp -r user@host:directory/SourceFolder TargetFolder

If the remote host ssh uses 44, you should specify (other than default port 22) in the command.  

scp -P 44 user@host:directory/SourceFile TargetFile

From a remote host to another remote host:

 scp user1@host1:/tmp/file_name user2@host2:/home/user2/

**  Important:   Don’t try tab button for auto completion of path when using remote host path. If you try ‘tab’ it will take the local host path only. Hence I request you to remember the actual path/location at remote host and use it.


Suggestions are always welcome..!  Without signing also you can send your comments.

Outlook 2007 - Restore or copy "AutoComplete suggest names" feature to another pc.

The AutoComplete suggest names are saved as Outlook.NK2 and you can copy that file from your old computer to new one.

             On old computer, please follow the steps:

o   If it is Microsoft Windows XP:

§  Click Start, and then click My Computer,

§  On the Tools menu, click Folder Options,

§  Click the View tab, and then,

§  under Advanced settings,

§  under Hidden files and folders,

§  Click Show hidden files and folders.

o   Go to "C:\Documents and Settings\&ltuser&gt\Application Data\Microsoft\Outlook"

o   Copy the file name Outlook.NK2 and Close Outlook in the new computer before pasting this file in the same location.

o   Restart the outlook to get it back.

o   If it is Windows 7: 

·  Open ‘My/ Computer’ or any folder and then click on Organize,

·  Here click on Folder and search Options,

·  Click the View tab, and then,

·   under Advanced settings,

·   under Hidden files and folders,

·   click Show hidden files and folders.

o   Go to "C:\Users\&ltuser&gt\AppData\Roaming\Microsoft\Outlook"

o   Copy the file name Outlook.NK2 and Close Outlook in the new computer before pasting this file in the same location.

o   Restart the outlook to get it back.

Suggestions are always welcome..!  Without signing also you can send your comments.

Download & Installing " OSGi JPA " Feature Pack using Installation Manager on WAS 7.0

Installing OSGi and JPA Fix Pack 1.0.0.1 Feature Pack using Installation Manager and Augmenting the Profile.

1. Download WAS import software to enable import option on installation manager-                                        http://public.dhe.ibm.com/software/websphere/downloads/was/import/ 
2. Download required OSGI and JPA feature pack-  http://www-01.ibm.com/support/docview.wss?uid=swg27020060
3. Or you can download a whole package from this link- http://www-01.ibm.com/software/webservers/appserv/was/featurepacks/osgi/instopt/index.html
4. Extract file to safe location. Better to extract it in IBM\Installation Manager Location (option)

Installation Instructions:

Perform the following tasks to install Feature Pack for OSGi & JPA Version 1.0.0.1 on WebSphere Application Server Version 7.0.0.9:

1. Install WebSphere Application Server V7.0.
2. Install WebSphere Application Server Fix Pack 7.0.0.9 using the Update Installer 7.0.
3. Install IBM Installation Manager. You can download and unpack a compressed file containing the Installation Manager appropriate for your operating system from the IBM Installation Manager Web site.
4. After Installation, start /open IBM Installation Manager.
5. We need to add repositories. Repository is a location where updates or extensions to the packages are stored.
6. Adding a repositories-
• Go to File > Preferences in installation manager. Click on "Add Repository". Browse for repository.config files from the extract (ariesjpa and WAS import repositories zip files).
• WAS import repo config file location : \local-repositories\repository.config
• Feature Pack config file location: < ariesjpa_ repositories > \ariesjpa\ repository.config

• ***Before importing Make sure to stop all (WAS Processes) servers and applications on the WebSphere Application Server installation that is being imported. ****
• Import WebSphere Application Server into Installation Manager.

• Install OSGi and JPA Fix Pack 1.0.0.1 using Update option on IBM Installation Manager main page. This can also be done by using either Web-based Repository or Local Repository.

• If you want you can check “Show all Versions” and click on “Check for other versions, fixes and extensions”

**Install Feature Pack for OSGi and JPA Version 1.x using IBM Installation Manager. This can be done by using either Web-based Repository or Local Repository. Whenever possible, you should use the remote Web-based repositories so that you are accessing the most up-to-date WebSphere Application Server base-product import and feature pack installation files. The feature-pack version of IBM Installation Manager is preconfigured to use both the local repositories (if they are set up) and the remote repositories. **

Augmentation:

1. After completing the installation of a feature pack, it requires to augment a profile to make the required profile compatible with a particular feature pack.
2.  You can augment the profile using the manageprofiles command or Profile Management tool (GUI).
3. Here I am going with Profile management tool:

**Note: It will allow selecting only one at a time

1. Select the particular profile to apply feature Pack.
2. After selecting click on “Augment”.

**Note: It will allow selecting only one at a time.

After installing JPA feature then start doing same exercise for OSGI.

Done !

Suggestions are always welcome..!  Without signing also you can send your comments.

Oracle sql developer - " Unable to find Java Virtual Machine ... "

After successful installation of Oracle 64 bit, When we try to open sql developer ( sqldeveloper.exe) , it ends up with the following error message:

"Unable to find Java Virtual Machine. To point to a location of a Java Virtual Machine, please refer to the Oracle Install Guide(java\install.html)."

Issue Resolved:

I found that the Oracle - SQL developer is NOT supported on 64 bit JDK. Hence I installed a 32 bit / x86 JDK and updated java loaction at sqldeveloper config file.

1. JDK Installation url:  http://www.oracle.com/technetwork/java/javase/downloads/jdk-6u25-download-346242.html 
2. Select windows x86, download and install jdk
3. Edit the “sqldeveloper.conf“
4. Location of conf file:  <OracleHome>\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
5.  Now point “SetJavaHome” to your 32 bit JDK location. 

Example: “SetJavaHome C:\Program Files (x86) \Java\jdk1.6.0_25“

Suggestions are always welcome..!  Without signing also you can send your comments.

pinging but not connecting with putty ssh

ssh service is not running
try to start it if not install it.
# apt-get install openssh-server

Suggestions are always welcome..!  Without signing also you can send your comments.

Cannot ping by hostname in ubuntu

Install samba it will work. If its already there then remove it.

For installing:
           :~# apt-get install samba
 For removing:
           :~# apt-get remove samba

Suggestions are always welcome..!  Without signing also you can send your comments.

Blogger: In home page, How to display only first few lines of the post with an option " Read More "

Login to your Blogger
Go To Template
Then Click On “Edit HTML”
Check Mark  “Expand Widget Templates”

Press Ctrl+F and search for this line   </head>

Now, copy below script and paste it above the </head> tag:

<script type='text/javascript'><!--//--><![CDATA[//><!-- function removeHtmlTag(strx,chop){     if(strx.indexOf("<")!=-1)     {         var s = strx.split("<");         for(var i=0;i<s.length;i++){             if(s[i].indexOf(">")!=-1){                 s[i] = s[i].substring(s[i].indexOf(">")+1,s[i].length);             }         }         strx =  s.join("");     }     chop = (chop < strx.length-1) ? chop : strx.length-2;     while(strx.charAt(chop-1)!=' ' && strx.indexOf(' ',chop)!=-1) chop++;     strx = strx.substring(0,chop-1);     return strx+'...'; } function createSummaryAndThumb(pID){     var div = document.getElementById(pID);     var imgtag = "";     var img = div.getElementsByTagName("img");     var summ = summary_noimg;     if(img.length>=1) {           imgtag = '<span style="float:left; padding:0px 10px 5px 0px;"><img src="'+img[0].src+'"   width="'+img_thumb_width+'px" height="'+img_thumb_height+'px"/></span>';         summ = summary_img;     }     var summary = imgtag + '<div>' + removeHtmlTag(div.innerHTML,summ) + '</div>';     div.innerHTML = summary; } //--><!]]></script>   <script type='text/javascript'> var thumbnail_mode = "no-float" ; summary_noimg = 530; summary_img = 440; img_thumb_height = 180; img_thumb_width = 180; </script>

Press Ctrl + F again and search for the below code:  (we are going to replace this code in next step)

<div class='post-header'>     <div class='post-header-line-1'/>     </div>     <div class='post-body entry-content'>       <data:post.body/>       <div style='clear: both;'/> <!-- clear for photos floats -->     </div> ***The below one is optional, you can keep it or replace it!*  <b:if cond='data:post.hasJumpLink'> <div class='jump-link'> <a expr:href='data:post.url + "#more"' expr:title='data:post.title'><data:post.jumpText/></a> </div> </b:if>

Replace it with below code:

<div class='post-header'>      <span class='post-author vcard'>        </span></div> <b:if cond='data:blog.pageType != "item"'>     <div class='post-body entry-content'>       <div expr:id='"summary" + data:post.id'><p><data:post.body/></p></div> <script type='text/javascript'>createSummaryAndThumb("summary<data:post.id/>");</script>       <div style='clear: both;'/> <!-- clear for photos floats -->     </div> </b:if> <b:if cond='data:blog.pageType == "item"'> <p><data:post.body/></p> </b:if> <div class='singleinfo'> <div style="float: right;"> <div style="font-weight: bold" class='readmore' > <b:if cond='data:blog.pageType != "item"'><a expr:href='data:post.url'>Read More >>></a> </b:if></div></div> </div>

Save the template/blog and your blog is ready as you like.

Suggestions are always welcome..!  Without signing also you can send your comments.

Subversion configuration in windows

Subversion configuration in windows

To create the repository, issue the following command:

svnadmin create c:/svnrepos

Create your SVN user: Now that your repository is successfully set up, you'll need to create an svn user.  Simply open the file c:/svnrepos/conf/svnserve.conf of your choice and add the following:

anon-access = none
auth-access = write
password-db = passwd

Now you'll need to create a password file: Open passwd file which is located at

c:/svnrepos/conf/passwd

Add a line in that file for your user in the format =

Example_user_name = example_password

Run the svn service: open command prompt (run as administrator)

sc create svnserve binpath= "\"C:\Program Files (x86)\Subversion\bin\svnserve.exe\" --service -r C:\svnrepos" displayname= "Subversion" depend= Tcpip start= auto

sc - is command to create service in windows

svnserve- is service name

binpath : path to executiable file

--service - is to start service at startup

c:\svnrepos: folder which you created in C-drive well act as SVN Repository

displayname : service name in services console

Start = auto - automatic start at system boot

depend= Tcpip - works on ip Check out your repository onto your local machine: Back on your local machine, go to where you keep your nerd stuff.  In my case it's in ~/workspace.  Then use the svn co command to check out a copy of your project.

Test the repo-browser: (need to install TortoiseSVN)

right click on Desktop -> tortoiseSVN -> Repo-browser

svn://localhost -> test if it works internally

svn://192.168.20.204 -> (Example for external ip) test if it works remotely

   

   Successfully Done..!

Suggestions are always welcome..!  Without signing also you can send your comments.

Creating WAS profiles using manageprofiles.sh command

Create a deployment manager profile

The following example creates a deployment manager profile:

./manageprofiles.sh -create -profileName dmgr01 -profilePath /opt/IBM/Websphere/Appserver/profiles/dmgr01 -templatePath  /opt/IBM/Websphere/Appserver/profileTemplates/dmgr -hostName 192.168.1.50 -nodeName dmgr01node01 -cellName cell01

Issue the following parameters:

-create

Creates a profile. (Required)

-templatePath template_path

Specifies the file path to the template. (Required)

Use the following format:

-templatePath install_root/profileTemplates/xd_augment/dmgr

-profileName

Specifies the name of the profile. (Optional)

-profilePath

Specifies the intended location of the profile in the file system. (Optional)

-hostName

Specifies the host name of the profile. (Optional)

-nodeName

Specifies the node name of the profile. The name must be unique within the cell. (Optional)

-cellName

Specifies the cell name of the profile. The cell name must be unique for each profile. (Optional)

-isDefault

Designates the profile as the default target of commands that do not use a profile parameter. (Optional)

-omitAction

Omits optional features. (Optional)

-adminUserName

Specifies the valid username for use with administrative security. (Optional)

-adminPassword

Specifies the password that is used with the name specified with the -adminUserName parameter. (Optional)

-portsFile

Specifies the path to a file that defines port settings for the new profile. Do not use this parameter with the -startingPort or -defaultPortsparameters. (Optional)

-startingPort

Specifies the starting port number for generating all ports for the profile. Do not use this parameter with the -portsFile or -defaultPortsparameters. (Optional)

-defaultPorts

Accepts the default ports for the new profile. Do not use this parameter with the -portsFile or -startingPort parameters. (Optional)

-validatePorts

Specifies which ports to validate to ensure the ports are not already in use or reserved. (Optional)

Create a custom profile

The following example creates a custom profile:

./manageprofiles.sh -create -profileName customNode01 -profilePath /export/home/wasadmin/IBM/Websphere/Appserver/profiles/customNode01 -templatePath  /export/home/wasadmin/IBM/Websphere/Appserver/profileTemplates/managed -hostName 192.168.1.50 -nodeName customNode01 -federateLater false -dmgrHost 192.168.1.50 -dmgrPort 8879 

Issue the following parameters:

-create

Creates a profile. (Required)

-templatePath template_path

Specifies the file path to the template. (Required)

Use the following format:

-templatePath install_root/profileTemplates/xd_augment/managed

-profileName

Specifies the name of the profile. The parameter is optional, but is issued by default if no values are specified.

-profilePath

Specifies the intended location of the profile in the file system. The parameter is optional, but is issued by default if no values are specified.

-hostName

Specifies the host name of the profile. The parameter is optional, but is issued by default if no values are specified.

-nodeName

Specifies the node name of the profile. The name must be unique within the cell. The parameter is optional, but is issued by default if no values are specified.

-cellName

Specifies the cell name of the profile. The cell name must be unique for each profile. The parameter is optional, but is issued by default if no values are specified.

-federateLater

Federates the node at a later time. Specify the value as true. The parameter is optional, but is issued by default if no values are specified.

-dmgrHost

Specifies the workstation in which the deployment manager is running. The parameter is optional, but is issued by default if no values are specified.

-dmgrPort

Specifies the SOAP port of the deployment manager. The parameter is optional, but is issued by default if no values are specified.

-isDefault

Designates the profile as the default target of commands that do not use a profile parameter. (Optional)

-omitAction

Omits optional features. (Optional)

-portsFile

Specifies the path to a file that defines port settings for the new profile. Do not use this parameter with the -startingPort or -defaultPortsparameters. (Optional)

-dmgrAdminUserName

Specifies the username of the deployment manager that you want to federate to. (Optional)

-dmgrAdminPassword

Specifies the password for the deployment manager that you want to federate to. (Optional)

Suggestions are always welcome..!  Without signing also you can send your comments.