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.

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.

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.

Double clicking the folder opens search instead of folder

This may cause due to installing some editable or listing software which adds a feature to folders.
When you right click on folder, search option will be on top of the action list. By default Double Click takes the first item in the action list. 
Hence, to get rid of this we need to set back it to default action value which is Open
How to Resolve:
Go to run or command prompt and execute the below command
regsvr32 /i shell32.dll






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

how to paste link target to the new column in excel

Below screen shot may help you…. Please let me know if you have any questions..

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

How can I select and delete all my unread emails in gmail?

1) type is:unread in the search feild.
2) check All
3) Click on "Select all conversations that match this search"
4) Delete it

Please wait for few minutes. If it doesn't redirect properly please logout from the account and try to relogin.
And you are all set !


Note: This can apply for read, unread, chat, starred also.

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

How to change multiple file extensions at once

If all files are located in one directory, I mean without any sub directories. Then its very simple.

Open a command window, enter into your directory and type  ren *.pdf *.tif 

this will change all files with extension .pdf to .tif. 

                                                         or

You can create a txt file copy ren *.pdf *.tif and save it into your directory where the files are located. Change the file extension .txt to .cmd and run it.  Done !

If you have a folder with different file of types (eg jpg/bmp/gif/ico/tga) and want to change ALL files to One type (eg png) then type:

ren *.* *.png

NB – All files in folder WILL change to .png!!

                                                   *****************************

Tool: If you have a directory full of files that need to be changed from .PNG to .JPG, it’s going to take forever to do this using the method above. That’s where you need a freeware application that can batch change file extensions for you.

Extension Renamer is a simple to use, freeware program that I have tested and contains no spyware, etc. Once you install it, it’s a piece of cake to change file extensions!

First, click Select Directory and choose the directory that contains all of the files that you want to modify. You have the option of including subdirectories also. Then you search for files with particular file extensions that you want to change. The *.* means that it will change ALL files to the new extension.

You can type in your the extension you want to change, such as .TXT in the From box along with an asterisk (*) or question mark (?) to help filter down the files. Click Search and the files that will be changed show up in the left box. Once you are satisfied, go ahead and click GO! Now all of your files will have their extensions renamed.


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