02-01-2007
ive got a nasty feeling somehow i've rm'd sh or what i was trying to do with the monitor program and installing that has corrupted or removed sh.
in which case how am i going to reinstall a shell!!! lol sounds like a nightmare. can always rebuild the box worst case but would like to avoid that
Cheers for the help by the way
10 More Discussions You Might Find Interesting
1. AIX
hi all,
Newbie to Unix and AIX. So my apologies if this is in the wrong place, etc.
Working on box -
uname# uname -a
AIX appt 3 5 00C08AAF4C00
when i type man (some valid command)
it just returns me to the # prompt.
Its running on the KSH shell.
man was working but i was trying... (6 Replies)
Discussion started by: djdavies
6 Replies
2. Solaris
I have two Dell x86 machines on which I am attempting to install Solaris 10 from CD. I am not doing a Jumpstart install. This is my first experience in installing Solaris (or any other OS). I am following the instructions at How to Quickly Install the Solaris 10 1/06 OS
The first machine... (3 Replies)
Discussion started by: sarahsi
3 Replies
3. UNIX for Dummies Questions & Answers
Hi all,
I have a virtual dedicated unix server somewhere (not sure we can put names, so ain't putting it yet :p)
anyway, I have problems using sendmail, but before I am asking for help, I don't get ANY manpages for sendmail on my machine.
I would like to try and solve this on my own (the... (2 Replies)
Discussion started by: saariko
2 Replies
4. UNIX for Dummies Questions & Answers
Hi folks,
Please advise which command/command line shall I run;
1) to display the command and its output on console
2) simultaneous to save the command and its output on a file
I tried tee command as follows;
$ ps aux | grep mysql | tee /path/to/output.txt
It displayed the... (7 Replies)
Discussion started by: satimis
7 Replies
5. Shell Programming and Scripting
Net::SSH::Perl ...... how to print the output in a proper format
my $cmd = "ls -l";
my $ssh = Net::SSH::Perl->new($host);
$ssh->login($user, $pass);
my($stdout, $stderr, $exit) = $ssh->cmd("$cmd");
print $stdout;
the script works fine, but i am unable to see the output... (2 Replies)
Discussion started by: gsprasanna
2 Replies
6. Shell Programming and Scripting
hello there,
there's a function, in my shell script, i'd like to run in the background.
here's an example:
log()
{
local SELF=${0##*/}
tty -s && echo ": $*"
}
some_func()
{
# do something
log "This text is not displayed in the terminal's output when running in the... (1 Reply)
Discussion started by: Shedon
1 Replies
7. Homework & Coursework Questions
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
I am trying to outut the man command output into a text file which will help me for future reference.
2.... (8 Replies)
Discussion started by: hariniiyer300
8 Replies
8. UNIX for Dummies Questions & Answers
I have came across a few websites stating some custom actions for Thunar -
crunchbang
ubuntu
I tried inputting the stated commands to Thunar, but it doesn't display at all in mine.
I tried "gksu thunar %f" ( Opens current folder with root permissions.) , but when I right click in a... (0 Replies)
Discussion started by: Hijanoqu
0 Replies
9. Shell Programming and Scripting
Please find my below requirement and see if you can help me on this. I am looking for a shell script which can provide me the below output.
Manuall steps which i am doing now
1) First I source the File
$ . ./WC_env.sh
2) Execute the command
$ /app/oracle/product/mos/bin/mosotl -url... (2 Replies)
Discussion started by: sudheshpn@gmail
2 Replies
10. SuSE
Hi,
I am using below code snippet to echo/display the files found
(matching a pattern from searchstring.out file) and the corresponding owner.
while read j
do
echo "Pattern to search is:- $j"
find / -name "*$j*" |\
while read k
do
echo "File found is:- $k"
owner=$(ls... (9 Replies)
Discussion started by: Vipin Batra
9 Replies
LEARN ABOUT REDHAT
reindex
REINDEX(7) SQL Commands REINDEX(7)
NAME
REINDEX - rebuild corrupted indexes
SYNOPSIS
REINDEX { TABLE | DATABASE | INDEX } name [ FORCE ]
INPUTS
TABLE Recreate all indexes of a specified table.
DATABASE
Recreate all system indexes of a specified database. (User-table indexes are not included.)
INDEX Recreate a specified index.
name The name of the specific table/database/index to be reindexed. Table and index names may be schema-qualified.
FORCE Force rebuild of system indexes. Without this keyword REINDEX skips system indexes that are not marked invalid. FORCE is irrelevant
for REINDEX INDEX, or when reindexing user indexes.
OUTPUTS
REINDEX
Message returned if the table is successfully reindexed.
DESCRIPTION
REINDEX is used to rebuild corrupted indexes. Although in theory this should never be necessary, in practice indexes may become corrupted
due to software bugs or hardware failures. REINDEX provides a recovery method.
REINDEX also removes certain dead index pages that can't be reclaimed any other way. See the "Routine Reindexing" section in the manual for
more information.
If you suspect corruption of an index on a user table, you can simply rebuild that index, or all indexes on the table, using REINDEX INDEX
or REINDEX TABLE.
Note: Another approach to dealing with a corrupted user-table index is just to drop and recreate it. This may in fact be preferable
if you would like to maintain some semblance of normal operation on the table meanwhile. REINDEX acquires exclusive lock on the ta-
ble, while CREATE INDEX only locks out writes not reads of the table.
Things are more difficult if you need to recover from corruption of an index on a system table. In this case it's important for the backend
doing the recovery to not have used any of the suspect indexes itself. (Indeed, in this sort of scenario you may find that backends are
crashing immediately at start-up, due to reliance on the corrupted indexes.) To recover safely, the postmaster must be shut down and a
stand-alone PostgreSQL backend must be started instead, giving it the command-line options -O and -P (these options allow system table mod-
ifications and prevent use of system indexes, respectively). Then issue REINDEX INDEX, REINDEX TABLE, or REINDEX DATABASE depending on how
much you want to reconstruct. If in doubt, use REINDEX DATABASE FORCE to force reconstruction of all system indexes in the database. Then
quit the standalone backend and restart the postmaster.
Since this is likely the only situation when most people will ever use a standalone backend, some usage notes might be in order:
o Start the backend with a command like
postgres -D $PGDATA -O -P my_database
Provide the correct path to the database area with -D, or make sure that the environment variable PGDATA is set. Also specify the name
of the particular database you want to work in.
o You can issue any SQL command, not only REINDEX.
o Be aware that the standalone backend treats newline as the command entry terminator; there is no intelligence about semicolons, as there
is in psql. To continue a command across multiple lines, you must type backslash just before each newline except the last one. Also, you
won't have any of the conveniences of command-line editing (no command history, for example).
o To quit the backend, type EOF (Control+D, usually).
See the postgres(1) reference page for more information.
USAGE
Recreate the indexes on the table mytable:
REINDEX TABLE mytable;
Rebuild a single index:
REINDEX INDEX my_index;
Rebuild all system indexes (this will only work in a standalone backend):
REINDEX DATABASE my_database FORCE;
COMPATIBILITY
SQL92
There is no REINDEX in SQL92.
SQL - Language Statements 2002-11-22 REINDEX(7)