09-22-2012
/db2home full issue in db2
Hi all,
I am new for linux environment, and i am working as a DBA.
I am facing some issues in OS level:
In our dev boxes /db2home under this directory i'm not finding any folder but it's showing 98% used .
/dev/dm-14 5.0G 4.6G 115M 98% /db2home
[root@vrdtisdbhcl01 db2home]# ls -lrt
total 16
drwx------ 2 root root 16384 Sep 7 11:11 lost+found
Could you please help me for this issue.
Thanks,
Suresh.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi...
I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies
2. Solaris
Hi All,
This is Babu working as a system administrator.
Here I am getting one problem with one of my Sun server's root (/) file system.
In df -h command / file system showing 7.8 GB used space.But in du -hd command it showing 5.2 gb only.
Please can any one help me resolve this issue... (2 Replies)
Discussion started by: lbreddy
2 Replies
3. Shell Programming and Scripting
/Path/snowbird9/nrfCompMgrRave1230100920.log.gz:09/20/2010 06:14:51 ERROR Error Message.
/Path/snowbird6/nrfCompMgrRave1220100920.log.gz:09/20/2010 06:14:51 ERROR Error Message.
/Path/snowbird14/nrfCompMgrRave920100920.log.gz:09/20/2010 06:14:51 ERROR Error Message.... (0 Replies)
Discussion started by: Shirisha
0 Replies
4. Shell Programming and Scripting
Hi
i m trying to connect DB2 via unix. it is successfully connect. but the connect is getting disconnect .
below is the query ,
countvalue=$(db2 "connect to <Database> user <username> using <Password>" | db2 -x 'select count(*) from <tablename>' ); echo $countvalue
while... (2 Replies)
Discussion started by: baskivs
2 Replies
5. Shell Programming and Scripting
Hi
I am extracting a column value(DESCRIPTION) from one table and passing it to another db2 statement in a shell code to fetch some value(ID) but the value when passed in where condition is taking as newline+value.
Please find the out put when executed:
+ echo description is ::::... (1 Reply)
Discussion started by: msp2244
1 Replies
6. Shell Programming and Scripting
hi
i am trying to execute db2 queries through shell script. it's working fine but for few queries is not working ( those queries are taking time so the script is not waiting to get the complete the execution of that query )
could you please any one help me on this
is there any wait... (1 Reply)
Discussion started by: bhaskar v
1 Replies
7. AIX
AIX Version 6.1 and 7.1.
I understand that when the OS initially creates the FS and inodes, its pretty strict, but not always tuned to a 1:1 ratio. I see the same thing when adding a whole disk LV to a separate device.
It seems that when we expand a filesystem the inodes don't get tuned... (5 Replies)
Discussion started by: mrmurdock
5 Replies
8. Shell Programming and Scripting
I have a shell script main.ksh We are calling dbscript.ksh from main.ksh
I am using select statement in dbscript.ksh but there is a problem with the select statement in dbscript.ksh but still echo $? is showing as zero. I am using DB2 commands in dbscript.ksh
Main.ksh
dbscript.ksh
echo $? ... (13 Replies)
Discussion started by: vamsi.valiveti
13 Replies
9. Programming
Dear Team,
I am using DB2 v10.5 and trying to load huge data using MERGE option ( 10-12 Million) using below query. Basically it loads data from staging to target . Staging table schemaname.Customer_Staging has 12 Million records . Runs for 25 Mins for just select query. But while doing merge... (2 Replies)
Discussion started by: Perlbaby
2 Replies
CHSH(1) User Commands CHSH(1)
NAME
chsh - change your login shell
SYNOPSIS
chsh [-s shell] [-l] [-u] [-v] [username]
DESCRIPTION
chsh is used to change your login shell. If a shell is not given on the command line, chsh prompts for one.
chsh is used to change local entries only. Use ypchsh, lchsh or any other implementation for non-local entries.
OPTIONS
-s, --shell shell
Specify your login shell.
-l, --list-shells
Print the list of shells listed in /etc/shells and exit.
-u, --help
Print a usage message and exit.
-v, --version
Print version information and exit.
VALID SHELLS
chsh will accept the full pathname of any executable file on the system. However, it will issue a warning if the shell is not listed in
the /etc/shells file. On the other hand, it can also be configured such that it will only accept shells listed in this file, unless you
are root.
EXIT STATUS
Returns 0 if operation was successful, 1 if operation failed or command syntax was not valid.
SEE ALSO
login(1), passwd(5), shells(5)
AUTHOR
Salvatore Valente <svalente@mit.edu>
AVAILABILITY
The chsh command is part of the util-linux package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux/.
util-linux July 2009 CHSH(1)