coolcommands.com - the search engine for unix sysadmins :: unix commands and scripts
Sunday May 27, 2012


 Home
 Search
 Advanced Search
 Category Search
 Affiliates
 Acknowledgements
 Cool Links

Username

Password

Remember me
Forgot your password?
Create an account

Who's Online
We have 21 guests online

Newest Member

beyondimagem

Hit Counter
9133536 Visitors

cool Statistics
coolcommands:1330
Categories:83
Total queries:595500
Members:16437





Category Search coolcommands.com
Select Category:


coolcommand

DB2 - add an alias for an IBM DB2 database
Description

To add an alias for an IBM DB2 database:

Add the new port assigned in the /etc/services file:

db2fncc 3740/tcp # DB2 connection port - original
db2fnci 3741/tcp # DB2 connection port new

Modify in DB2:

db2dbname = database name
hostname = name of your server
db2fncc = name of your new instance (alias)
db2fnc = DB2 user name

# su - db2user

# db2 catalog tcpip node db2dbname remote hostname server db2fncc

# db2 catalog database db2dbname as dbsuser at node db2dbname
Example

db2 catalog tcpip node db2dbname remote hostname server db2fncc

Return to search results

Random coolcommands

coolcommand: comm - select or reject lines common to two sorted files
Example: comm file1 file2
[show me the details]
coolcommand: rrdtool - read data from a rrdtool (round robin database) database file
Example: rrdtool fetch cpu.rrd AVERAGE -r 900 -s -1h
[show me the details]
coolcommand: how to delete a row from a mysql database table
Example: delete from user where user='stephane';
[show me the details]
coolcommand: how to find profile information for a particular LPAR on a managed system from a HMC
Example: lssyscfg -r prof -m frameprd1-9117-MMA-SN0644556 -F --filter lpar_names=aixweb01
[show me the details]

coolcommands.com - the search engine for UNIX sysadmins :: unix commands and scripts



FREE
myPMS

Password
Management
System

by

LVOware.com




Top 5 Submitters

lvo1152
audet37
kah00na32
Mariom24
lebjf00014

Top 5 Searches

Category Solaris49379
Category AIX46267
Category General UNIX43933
solaris22927
aix22116

Terms of Use
Privacy
Contact


 
coolcommands.com © 2012. All Right Reserved.
Programming by PRATTICO Consulting . Hosting by Apricusum