Redbook Draft: High Availability and Disaster Recovery Options for DB2 Linux, UNIX, and Windows

Created:
Last Update:

Author: Christoph Stoettner
Read in about 1 min · 28 words

Fountain pen and a notebook

Photo by Aaron Burden | Unsplash

Author
Suggested Reading
Aaron Burden: Fountain pen and a notebook

Today i read a question in the IBM Connections Forum about setting the EMPLOYEE_EXTENDED role to all users in a Connections deployment.

Created:
Last Update:
Read in about 1 min
Aaron Burden: Fountain pen and a notebook

Missing command history on Linux is a little problem when using command line utilities like wsadmin, db2, sqlplus and so on.

I found a solution for this today.

You can use rlwrap to get command history for all applications on the console and it is possible to recall and edit the commands. Rlwrap uses readline.

Installation on CentOS:

yum install readline-static gcc make
tar -xvzf rlwrap-0.41.tar.gz
cd rlwrap-0.41
./configure
make
make install

Call rlwrap with wsadmin:

rlwrap -r /opt/IBM/WebSphere/AppServer/profiles/Dmgr01/bin/wsadmin.sh -lang jython -username wasadmin -password password

rlwrap and db2

rlwrap -r db2

Use rlwrap everytime with alias

vim ~/.bash_profile
export WAS_HOME=/opt/IBM/WebSphere/AppServer
export DMGR=Dmgr01
alias db2='rlwrap -r db2'
alias wsadmin='cd $WAS_HOME/profiles/$DMGR/bin;rlwrap -r ./wsadmin.sh -lang jython'
Created:
Last Update:
Read in about 1 min
Aaron Burden: Fountain pen and a notebook

Today i spoke at Social Connections V User Group Meeting in Zurich. What should i say. It was a pleasure and i enjoyed it very much. Hope we can discuss more scripts the next weeks.

Session Slides

Here you can watch the session slides:

Saving my time using scripts #soccnx #soccnxv

Scripts Download

You can download all scripts without warranty and on your own risk on:

http://www.github.com/stoeps13/ibmcnxscripting

Please download the master branch, develop and bugfix can contain not ready scripts.

Slidedownload soccnx

More Slides on http://www.slideshare.net/soccnx

Created:
Last Update:
Read in about 1 min