[LUW] Setting the log path on DB2 for AIX

Aurora Emanuela Dell'Anno

[LUW] Setting the log path on DB2 for AIX
I assume it needs doing at DB creation time - however, how do I tell DB2
to use a certain path to a log file?

Thanks.

Aurora

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Philip Gunning

Re: [LUW] Setting the log path on DB2 for AIX
(in response to Aurora Emanuela Dell'Anno)
Dbe update db cfg for xxx using newlogpath /db2_logs

Usuallu we use this put the ligs on separate disks pg
Sent via BlackBerry by AT&T

-----Original Message-----
From: "Dell'Anno,Aurora Emanuela,BUSSIGNY,Contractor for NBS IS/IT" <[login to unmask email]>

Date: Tue, 27 Nov 2007 14:16:25
To:[login to unmask email]
Subject: [DB2-L] [LUW] Setting the log path on DB2 for AIX


I assume it needs doing at DB creation time - however, how do I tell DB2 to use a certain path to a log file?
Thanks.
Aurora

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Aurora Emanuela Dell'Anno

Re: [LUW] Setting the log path on DB2 for AIX
(in response to Philip Gunning)
Thanks Phil,

I assume therefore that it is not possible to define it at DB creation
time?

Aurora

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Phil gunning
Sent: 27 November 2007 15:41
To: [login to unmask email]
Subject: Re: [DB2-L] [LUW] Setting the log path on DB2 for AIX

Dbe update db cfg for xxx using newlogpath /db2_logs

Usuallu we use this put the ligs on separate disks pg Sent via
BlackBerry by AT&T

-----Original Message-----
From: "Dell'Anno,Aurora Emanuela,BUSSIGNY,Contractor for NBS IS/IT"
<[login to unmask email]>

Date: Tue, 27 Nov 2007 14:16:25
To:[login to unmask email]
Subject: [DB2-L] [LUW] Setting the log path on DB2 for AIX


I assume it needs doing at DB creation time - however, how do I tell DB2
to use a certain path to a log file?
Thanks.
Aurora

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion
listserv that are being implemented to improve reliability and the
overall user experience of DB2-L. These changes are coming on November
30th. Details at http://www.idug.org

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Philip Gunning

Re: [LUW] Setting the log path on DB2 for AIX
(in response to Aurora Emanuela Dell'Anno)
Looks like I didn't have my coffee yet. Shoulld have been db2 update db cfg for xxx using newlogpath /db2_logs
Pg
Sent via BlackBerry by AT&T

-----Original Message-----
From: "Phil gunning" <[login to unmask email]>

Date: Tue, 27 Nov 2007 14:40:49
To:"Db2l" <[login to unmask email]>
Subject: Re: [DB2-L] [LUW] Setting the log path on DB2 for AIX


Dbe update db cfg for xxx using newlogpath /db2_logs

Usuallu we use this put the ligs on separate disks pg
Sent via BlackBerry by AT&T

-----Original Message-----
From: "Dell'Anno,Aurora Emanuela,BUSSIGNY,Contractor for NBS IS/IT" <[login to unmask email]>

Date: Tue, 27 Nov 2007 14:16:25
To:[login to unmask email]
Subject: [DB2-L] [LUW] Setting the log path on DB2 for AIX


I assume it needs doing at DB creation time - however, how do I tell DB2 to use a certain path to a log file?
Thanks.
Aurora

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Philip Gunning

Re: [LUW] Setting the log path on DB2 for AIX
(in response to Philip Gunning)
No, not at create at least as of 9.5....see below



[login to unmask email]:~> db2 ? create db
CREATE DATABASE database-name
[AT DBPARTITIONNUM | [AUTOMATIC STORAGE {NO | YES}]
[ON path[{,path}...][DBPATH ON path]]
[ALIAS database-alias] [USING CODESET codeset TERRITORY territory]
[COLLATE USING {SYSTEM | IDENTITY | IDENTITY_16BIT | COMPATIBILITY | NLSCHAR}]
[PAGESIZE integer [K]]
[NUMSEGS numsegs] [DFT_EXTENT_SZ dft_extentsize] [RESTRICTIVE]
[CATALOG TABLESPACE tblspace-defn] [USER TABLESPACE tblspace-defn]
[TEMPORARY TABLESPACE tblspace-defn] [WITH "comment-string"]]
[AUTOCONFIGURE [USING config-keyword value [{,config-keyword value}...]]
[APPLY {DB ONLY | DB AND DBM | NONE}]]

tblspace-defn:
MANAGED BY { SYSTEM USING ('string' [ {,'string'} ... ] ) |
DATABASE USING ({FILE | DEVICE} 'string' number-of-pages
[ {,{FILE | DEVICE} 'string' number-of-pages} ... ]) | AUTOMATIC STORAGE}
[EXTENTSIZE number-of-pages] [PREFETCHSIZE number-of-pages]
[OVERHEAD number-of-milliseconds] [TRANSFERRATE number-of-milliseconds]
[NO FILE SYSTEM CACHING | FILE SYSTEM CACHING]
[AUTORESIZE {NO | YES}] [INITIALSIZE integer {K |M |G}]
[INCREASESIZE integer {PERCENT |K |M |G}] [MAXSIZE {NONE | integer {K |M |G}}]

config-keyword:
MEM_PERCENT, WORKLOAD_TYPE, NUM_STMTS, TPM, ADMIN_PRIORITY
NUM_LOCAL_APPS, NUM_REMOTE_APPS, ISOLATION, BP_RESIZEABLE.

NOTE: From the operating system prompt, prefix commands with 'db2'.
Special characters MAY require an escape sequence (\), for example:
db2 \? change database
db2 ? change database xxx comment with \"text\"
[login to unmask email]:~>

sdr 85.23 0.00 73746.11 0 369468
sds 0.00 0.00 0.00 0 0
sdt 0.00 0.00 0.00 0 0
sdu 0.00 0.00 0.00 0 0
sdv 0.00 0.00 0.00 0 0
sdw 0.00 0.00 0.00 0 0
sdx 0.00 0.00 0.00 0 0
sdy 0.00 0.00 0.00 0 0
sdz 0.00 0.00 0.00 0 0
sdaa 0.00 0.00 0.00 0 0
sdab 0.00 0.00 0.00 0 0
sdac 0.00 0.00 0.00 0 0
sdad 0.00 0.00 0.00 0 0
sdae 0.00 0.00 0.00 0 0
sdaf 0.00 0.00 0.00 0 0
sdag 0.00 0.00 0.00 0 0
sdah 0.00 0.00 0.00 0 0
sdai 0.00 0.00 0.00 0 0
sdaj 0.00 0.00 0.00 0 0
sdak 0.00 0.00 0.00 0 0
sdal 0.00 0.00 0.00 0 0
sdam 0.00 0.00 0.00 0 0
sdan 2.40 2452.69 0.00 12288 0
sdao 3.59 3669.46 0.00 18384 0
sdap 7.39 6537.33 0.00 32752 0
sdaq 8.98 7939.32 0.00 39776 0
sdar 9.78 8175.65 0.00 40960 0
sdas 8.38 7932.93 0.00 39744 0
sdat 6.19 5936.93 0.00 29744 0
sdau 3.59 3506.59 0.00 17568 0
sdav 3.99 4087.82 0.00 20480 0
sdaw 4.19 4292.22 0.00 21504 0
sdax 0.00 0.00 0.00 0 0
sday 0.00 0.00 0.00 0 0
sdaz 0.00 0.00 0.00 0 0
sdba 0.00 0.00 0.00 0 0
sdbb 0.00 0.00 0.00 0 0
sdbc 0.00 0.00 0.00 0 0
sdbd 0.00 0.00 0.00 0 0
sdbe 0.00 0.00 0.00 0 0
sdbf 0.00 0.00 0.00 0 0
sdbg 0.00 0.00 0.00 0 0
dm-0 0.00 0.00 0.00 0 0
dm-1 0.00 0.00 0.00 0 0
dm-2 0.00 0.00 0.00 0 0
dm-3 0.00 0.00 0.00 0 0
dm-4 54.09 52119.76 0.00 261120 0
dm-5 0.00 0.00 0.00 0 0
dm-6 295.01 0.00 268166.27 0 1343513

avg-cpu: %user %nice %system %iowait %steal %idle
0.20 0.00 0.97 20.42 0.00 77.38

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Phil gunning
Sent: Tuesday, November 27, 2007 9:47 AM
To: [login to unmask email]
Subject: Re: [DB2-L] [LUW] Setting the log path on DB2 for AIX

Looks like I didn't have my coffee yet. Shoulld have been db2 update db cfg for xxx using newlogpath /db2_logs
Pg
Sent via BlackBerry by AT&T

-----Original Message-----
From: "Phil gunning" <[login to unmask email]>

Date: Tue, 27 Nov 2007 14:40:49
To:"Db2l" <[login to unmask email]>
Subject: Re: [DB2-L] [LUW] Setting the log path on DB2 for AIX


Dbe update db cfg for xxx using newlogpath /db2_logs

Usuallu we use this put the ligs on separate disks pg
Sent via BlackBerry by AT&T

-----Original Message-----
From: "Dell'Anno,Aurora Emanuela,BUSSIGNY,Contractor for NBS IS/IT" <[login to unmask email]>

Date: Tue, 27 Nov 2007 14:16:25
To:[login to unmask email]
Subject: [DB2-L] [LUW] Setting the log path on DB2 for AIX


I assume it needs doing at DB creation time - however, how do I tell DB2 to use a certain path to a log file?
Thanks.
Aurora

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

[login to unmask email]

Re: [LUW] Setting the log path on DB2 for AIX
(in response to Philip Gunning)
On Tuesday 27 November 2007 08:16:25 Dell'Anno,Aurora
Emanuela,BUSSIGNY,Contractor for NBS IS/IT wrote:
> I assume it needs doing at DB creation time - however, how do I tell DB2
> to use a certain path to a log file?
>
> Thanks.
>
> Aurora
>
> IMPORTANT NOTICE:
>
> IDUG is pleased to announce a series of upgrades to the DB2-L discussion
> listserv that are being implemented to improve reliability and the overall
> user experience of DB2-L. These changes are coming on November 30th.
> Details at http://www.idug.org
>
> ---------------------------------------------------------------------------
>------ Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives
> and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
> page select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at
> [login to unmask email] Find out the latest on IDUG conferences at
> http://conferences.idug.org/index.cfm

You need to set the "newlogpath" db cfg paramater and deactivate and
reactivate, or recycle, the database. The value must be a fully qualified
path.

--

--------------------------------------------------------------
Registered Linux User #169330 ( http://counter.li.org )
Pure Linux (SUSE) User
GnuPGP key available on request
Jaxtr Phone: http://www.jaxtr.com/dlj53tx

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm