Sunday, July 17, 2011

How to share Windows folder on Ubuntu (guest OS)

My system environment looks as follows - Windows host with Ubuntu 10 guest OS in VMWare

I followed the below URL from wmware to setup Windows share on Ubuntu. http://www.vmware.com/support/ws3/doc/ws32_running9.html. But this did not quiet work in a single given the fact that I am new to Ubuntu/Window intraction.

Try command "smbmount" if this works that means the smb pieces are install, else install them

if smb components are not install then run "apt-get install smbfs" - ensure that the installation goes correct.

Create a directory that will be mapped to window share "mkdir /home/gvphubli/win_shared"

Here is the last command in this process

mount -t smbfs -o username=win_user,password=win_user_pwd 
//win_system_IP/Java_Learning  /home/gvphubli/win_shared 


In case of CentOS or Fedora follow these steps,

Test for samba, run this command in terminal "smbd -V" if samba is installed and available the version number will be displayed, else you will see bash error.

If you see error, install samba using following steps, I used my root privileges to do so.

yum install samba-swat samba-client

After successfull installation, use the same command "smbd -V" to verify. If things look good go to next stop of creating a mount, here is he command

mount -t cifs -o username=win_user,password=win_user_pwd //win_system_IP/Java_Learning  /home/gvphubli/win_shared

Note: one difference in this command for Ubuntu v/s RH (Fedora and CentOS) is the change from "smbfs" to "cifs"

You should be all set to share files between host and guest OS

...

Friday, July 8, 2011

db2 restore with mix of full and incremental backups

Following are the steps to restore db2 database when you have mix of db backup with full, incremental and delta are involved.This illustration is based on Windows system.

text in blue are db2 commands
text in green are my comments
text in black are output seen on command line console.

db2 create db zzz_tmp
db2 restore db zzz incremental automatic from C:\ taken at 20110707154108 into zzz_tmp
db2 rollforward db zzz_tmp to end of backup and complete

-- you will see following message, if roll-forward is not complete

SQL4970N Roll-forward recovery on database "ZZZ_TMP" cannot reach the
specified stop point (end-of-log or point-in-time) on database partition(s)
"0". Roll-forward recovery processing has halted on log file "S0000026.LOG".

-- if you see a message as listed above you need to get(copy or restore from TSM)
-- the specified log file to zzz_tmp's active log directory

db2 rollforward db zzz_tmp to end of backup and complete

-- if successfull (you mostly will be) you will see following message

Rollforward Status


Input database alias = zzz_tmp
Number of nodes have returned status = 1
Node number = 0
Rollforward status = not pending
Next log file to be read = Log files processed = S0000026.LOG - S0000026.LOG
Last committed transaction = 2011-07-07-22.41.13.000000 UTC


DB20000I The ROLLFORWARD command completed successfully.

-- do some smoke testing, by connecting and possibly quering the db

db2 connect to zzz_tmp

Database Connection Information
Database server = DB2/NT 9.7.0
SQL authorization ID = db2admin
Local database alias = ZZZ_TMP

About Me

By profession I am a Database Administrator (DBA) with total 13 yrs. of experience in the field of Information Technology, out of that 9 yrs as SQL DBA and last 3 years in IBM System i/iSeries and DB2 LUW 9. I have handled Developer, plus production support roles, and I like both the roles. I love and live information technology hence the name "Techonologyyogi" Apart from that I am a small, retail investor, with small investments in India and United States in the form of Equity holdings via common stocks. Don't ask me if I have made money, I have been loosing money in stocks.