Getting the AIX file paths

Richard Hagedorn

Getting the AIX file paths
Is there a quick and easy way to get the file path info for all the files on
an AIX/DB2 instance? Maybe something like a describe command?



Thanks,

Richard


---------------------------------------------------------------------------------
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

David Wilson (Interactive)

Re: Getting the AIX file paths
(in response to Richard Hagedorn)
Richard,

You can get the high level directory info by using the following commands

db2 get dbm cfg | egrep '(PATH|Path)'
db2 get db cfg for $DBNAME | egrep '(PATH|Path)'



David Wilson
Interactive DB2 DBA
Camelot Group plc
(W) +44(0)1923-425049
(M) +44(0)7916-268306
Play Lotto Online at <www.national-lottery.co.uk>

-----Original Message-----
From: Richard Hagedorn [mailto:[login to unmask email]
Sent: 11 January 2005 01:30
To: [login to unmask email]
Subject: [DB2-L] Getting the AIX file paths



Is there a quick and easy way to get the file path info for all the files on
an AIX/DB2 instance? Maybe something like a describe command?



Thanks,

Richard


________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk < http://www.star.net.uk >
________________________________________________________________________
----------------------------------------------------------------------------
----- 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



**********************************************************************
The information contained in this e-mail may be confidential. It is intended
only for the use of the named recipient. If you are not the named recipient
please delete this e-mail. If you have received this e-mail and are not the
named recipient, any disclosure, reproduction, distribution or other
dissemination or use of the information contained in this e-mail is strictly
prohibited.
E-Mail transmission cannot be guaranteed to be secure or error free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message which
arise as a result of e-mail transmission. If verification is required please
request a hard copy version.
Registered Office:
Camelot Group plc
Tolpits Lane
Watford
WD18 9RN
Tel : 01923 425000
Registered in England & Wales
No. 2822203
**********************************************************************



________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________

---------------------------------------------------------------------------------
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

Richard Hagedorn

Re: Getting the AIX file paths
(in response to David Wilson (Interactive))
Thank you, This is exactly what I need.



_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of David Wilson (Interactive DBA)
Sent: Tuesday, January 11, 2005 6:07 AM
To: [login to unmask email]
Subject: Re: [DB2-L] Getting the AIX file paths



Richard,



You can get the high level directory info by using the following commands



db2 get dbm cfg | egrep '(PATH|Path)'

db2 get db cfg for $DBNAME | egrep '(PATH|Path)'





David Wilson
Interactive DB2 DBA
Camelot Group plc
(W) +44(0)1923-425049
(M) +44(0)7916-268306
__________________________________________

----------------------------------------------------------------------------
----- 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

---------------------------------------------------------------------------------
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