Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Unable to Eject or Use CDROM
Hi, You can also do a : fuser /cdrom to see the process # holding the cdrom. fuser -k /cdrom -- to kill the process that is using the cdrom If this doesn't work use the device name instead of /cdrom. Hope this helps. Nana- snana
- Post #5
- Forum: Sun: Solaris
-
db2start not working
Hi Rane, From the DB2 command line : db2 get dbm cfg and see what is set for SYSADM_GROUP and make sure your ID (NT ID) is part of that group. Hope this helps. Regards Nana Srinivasan -
How do I process multi-column data in ksh script
Hi Tison, You could do this in multiple ways. Here are 3 ways you could do this. 1. cat filename | while read FIELD1 FIELD2 FILED3 do cp /tmpdir/$FIELD1 /otherdir/$FIELD3.$FIELD2.$FIELD1 done 2. exec 3< filename while read -u3 FIELD1 FIELD2 FIELD3 do cp /tmpdir/$FIELD1... -
Suppress column headings & rows counts in CLP
Hi, The SQL you are using is fine. With that statement in a file (r.sql) you can do : db2 -tvf r.sql | grep "^RUNSTATS" > runstats.sql This will just get the RUNSTATS statement. In DB2 V7 there is a -x flag that gets rid of the header and footer information. Nana -
db2start not working
Hi Rane, What is the OS ? What is the DB2 version and fixpack that you have installed ? Check if you have enough space in the home directory of the instance. Also, check the $HOME/sqllib/db2dump/db2diag.log for error messages. Nana -
Using sed to edit string and save the new info to the same file
Hi, You cannot use the same filename for input and output. sed "s/foo/bar/g" file1 > file2 mv file2 file1 Hope this helps. Nana -
ssaraid on aix 4.3.3 does not show strip_size
Hi all, I am trying to find the strip_size of the raid_5 ssaraid that we have on our Database server (DB2). I am using the following command to find it : ssaraid -I -l ssa1 -n hdisk2 This doies not show the strip_size value on this system but it shows this on another system. Can anyone tell me...
