HP-Unix machine is 32 or 64 bit?
HP-Unix machine is 32 or 64 bit?
Method 1:
# getconf KERNEL_BITS
Method 2:
# ps -ef |grep RT
Method 3:
# file /stand/vmunix
If 64 bit it will show something like: ELF-64 executable object file
HP-Unix machine is 32 or 64 bit?
Method 1:
# getconf KERNEL_BITS
Method 2:
# ps -ef |grep RT
Method 3:
# file /stand/vmunix
If 64 bit it will show something like: ELF-64 executable object file
1. Login as root and do ioscan before add the Lun to the Unix Machine
# ioscan -fnCdisk
2. Add the lun to Unix machine by EMC Navigator
3. No need to restart the Unix machine do the ioscan again will show you the newly added disk as CLAIMED but devices will not show
#ioscan -fnCdisk
This is a short script that allows you to extract the SQL from an export file. It is intended for use on UNIX machines. Instructions are in the header of the script.
When entering the script ensure: A> The first line in the file should be a single colon (:)
Please note this is a proto-type script so there may be some statements in the resultant file that need manual editting.
:
$ imp user/password file=exportfile show=Y log=/tmp/showfile
$ ./impshow2sql /tmp/showfile > /tmp/imp.sql
Note: This script may split lines incorrectly for some statements so it is best to check the output.
# CONSTRAINT “” problem:
# You can use this script to help get the SQL from an export then correct it if it includes bad SQL such as CONSTRAINT “”.
# Eg:
# Use the steps above to get a SQL script and then
# $ sed -e ‘s/CONSTRAINT “”//’ infile > outfile
Now precreate all the objects and import the export file.
#
# Extracting Specific Statements only:
# It is fairly easy to change the script to extract certain statements only. For statements you do NOT want to extract change N=1 to N=0 Eg: To extract CREATE TRIGGER statements only:
a) Change all lines to set N=0.
Eg: / \”CREATE / { N=0; }
This stops CREATE statements being output.
b) Add a line (After the general CREATE line above):
/ \”CREATE TRIGGER/ { N=1; }
This flags that we SHOULD output CREATE TRIGGER statements.
c) Run the script as described to get CREATE TRIGGER statements.
awk ‘ BEGIN { prev=”;” }
/ \”CREATE / { N=1; }
/ \”ALTER / { N=1; }
/ \”ANALYZE / { N=1; }
/ \”GRANT / { N=1; }
/ \”COMMENT / { N=1; }
/ \”AUDIT / { N=1; }
N==1 { printf “\n/\n\n”; N++ }
/\”$/ { prev=”"
if (N==0) next;
s=index( $0, “\”" );
if ( s!=0 ) {
printf “%s”,substr( $0,s+1,length( substr($0,s+1))-1 )
prev=substr($0,length($0)-1,1 );
}
if (length($0)<78) printf( "\n" );
}' $*
Alibi3col theme by
Themocracy