| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
|
02-02-09, 22:02
|
|
Registered User
|
|
Join Date: Dec 2008
Location: Toronto, Canada
Posts: 381
|
|
|
how to copy dbm cfg parameters?
|
|
If I created a new instance and want to have dbm cfg parameters same as of other instances, how to I do it? Or to update every parameter one by one is the only way?
Thanks in advance
__________________
DB2 v9.5 ESE on AIX v6.1/ v9./10 on z/OS
|
|
02-03-09, 00:13
|
|
Registered User
|
|
Join Date: May 2003
Location: USA
Posts: 5,196
|
|
AFAIK, that is the only way.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
|
|
02-03-09, 00:19
|
|
Registered User
|
|
Join Date: Dec 2008
Posts: 59
|
|
|
|
hope that will help you...
Code:
mysql> CREATE TABLE demo(id_no INTEGER NOT NULL PRIMARY KEY,val DECIMAL(10,2));
Code:
mysql> INSERT INTO demo VALUES (5,200.00),(6,100.00),(5,000.00),(5,700.00),(2,100.00);
|
|
02-03-09, 06:38
|
|
Registered User
|
|
Join Date: May 2003
Location: USA
Posts: 5,196
|
|
Quote:
|
Originally Posted by hkp819
hope that will help you...
|
I think you have had one too many beers.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
|
|
02-03-09, 07:10
|
|
Registered User
|
|
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
|
|
No, I think he has no clue what DB2 dbm cfg parameters are.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
|
|
02-03-09, 07:55
|
|
Super Moderator
|
|
Join Date: Aug 2001
Location: UK
Posts: 4,534
|
|
I have to agree with Marcus on this one ... Have a look at his other response:
Convert Statement in db2
 
Quote:
|
Originally Posted by stolze
No, I think he has no clue what DB2 dbm cfg parameters are.
|
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
|
|
02-03-09, 08:01
|
|
Registered User
|
|
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
|
|
No, I think he's on the wrong forum
|
|
02-03-09, 08:48
|
|
:-)
|
|
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
|
|
Quote:
|
Originally Posted by Marcus_A
AFAIK, that is the only way.
|
"db2look -f" retrieves _some_ instance configuration parameters. Also, Configuration Assistant can be used to export and import DBM configuration.
|
|
02-03-09, 10:35
|
|
Registered User
|
|
Join Date: Dec 2008
Location: Toronto, Canada
Posts: 381
|
|
|
__________________
DB2 v9.5 ESE on AIX v6.1/ v9./10 on z/OS
|
|
02-04-09, 22:13
|
|
∞∞∞∞∞∞
|
|
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
|
|
Take a look at db2cfexp and db2cfimp. For example;
db2cfexp <output file name> backup -> this will export your config info
db2cfimp <output file name> -> this will import your config info
db2cfexp exports more than just dbm cfg, but you can edit the output file to remove what you don't need.
|
|
02-05-09, 00:24
|
|
Registered User
|
|
Join Date: May 2003
Location: USA
Posts: 5,196
|
|
Quote:
|
Originally Posted by db2girl
Take a look at db2cfexp and db2cfimp. For example;
db2cfexp <output file name> backup -> this will export your config info
db2cfimp <output file name> -> this will import your config info
db2cfexp exports more than just dbm cfg, but you can edit the output file to remove what you don't need.
|
I thought that program is for exporting the client config, and not the server config?
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
|
|
02-05-09, 00:31
|
|
∞∞∞∞∞∞
|
|
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
|
|
I use it on the server (ie. prior to dropping/recreating the instance). Here is an example:
db2cfexp db2cfexpt.out backup
From db2cfexpt.out:
[DBM_CONFIG]
NODETYPE=3
RELEASE=0xa00
DIAGLEVEL=3
RQRIOBLK=32767
DOS_RQRIOBLK=0
AUTHENTICATION=0
DIR_CACHE=1
DISCOVER=2
TP_MON_NAME=
DIAGPATH=
SYSADM_GROUP=BUILD
SYSCTRL_GROUP=
SYSMAINT_GROUP=
SYSMON_GROUP=
TM_DATABASE=1ST_CONN
.....
|
|
02-06-09, 09:33
|
|
Registered User
|
|
Join Date: Dec 2008
Location: Toronto, Canada
Posts: 381
|
|
Quote:
|
Originally Posted by db2girl
Take a look at db2cfexp and db2cfimp. For example;
db2cfexp <output file name> backup -> this will export your config info
db2cfimp <output file name> -> this will import your config info
db2cfexp exports more than just dbm cfg, but you can edit the output file to remove what you don't need.
|
So should I remove params I don't want to change in the destination instance cfg and then import?
I noticed some params are not there/do not get exported (e.g., JDK_PATH, DIAGPATH). And there is database info I don't need. So I just remove those lines from export file?
__________________
DB2 v9.5 ESE on AIX v6.1/ v9./10 on z/OS
|
|
02-06-09, 14:16
|
|
∞∞∞∞∞∞
|
|
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
|
|
Yes, you can edit the file to remove what you don't need. some dbm cfg parameters are NULL by default so they won't contain any value. diagpath is one of them.
|
Last edited by db2girl; 02-06-09 at 14:51.
|
02-06-09, 15:08
|
|
Registered User
|
|
Join Date: Dec 2008
Location: Toronto, Canada
Posts: 381
|
|
|
__________________
DB2 v9.5 ESE on AIX v6.1/ v9./10 on z/OS
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
how to copy dbm cfg parameters?
