creation date of DBSPACES and CHUNKS
Posted in 2007
Topics: Storage & Space Management, Server Administration, Platform-Specific Issues, Internationalization & Character Sets
Actually, you can see when the dbspace was created through the onmonitor command. Chunks: nope, at least not via onmonitor. Take care. Clifton M. Bean Informix DBA / AIX System Admin Currency Technics & Metrics Phone: (972) 812-1411 x244 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ART KAGEL, BLOOMBERG/ 731 LEXIN Sent: Wednesday, October 17, 2007 10:28 AM To: ids@iiug.org Subject: CP1252?Q52=65=3A=44=62=73=70=61=63=65=73=20=79.... [10172] Only be parsing through the message log (MSGPATH) Art S. Kagel ----- Original Message ----- From: Juan Pablo <ids@iiug.org> To: ids@iiug.org At: 10/17 11:15:00 Hi all: Is it possible to see the creation date of DBSPACES and CHUNKS. Thank you _________________________________________________________________ Windows Live Messenger, la nueva generación de tu MSN. http://imagine-msn.com/minisites/messenger/default.aspx?locale=es-ar **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
For chunk creation date, this may not be the exact science, but perhaps we try
checking on -- not links -- but the active raw devices (those attached and
used by the Informix instance).
For example:
onstat -d | grep irv1105b00be18 221 30 1 1048574 963571 PO- /product/irv110
ls -al /product/irv110
/product
lrwxrwxrwx 1 informix informix 36 Jan 28 2005 /product/irv110 ->
/dev/vx/rdsk/product_instance/irv110
ls -al /dev/vx/rdsk/product_nywebdb6/irv110
/product
crw-rw---- 1 informix informix 275,81219 Mar 11 2007
/dev/vx/rdsk/product_instance/irv110
so the creation date of this chunk is Mar 11, 2007 as long as noone changes
the date of this device for example with "touch" command by Informix ID.
----- Original Message ----
From: Clifton Bean <cbean@ctm.com>
To: ids@iiug.org
Sent: Wednesday, October 17, 2007 11:34:41 AM
Subject: creation date of DBSPACES and CHUNKS [10174]
Actually, you can see when the dbspace was created through the onmonitor
command. Chunks: nope, at least not via onmonitor.
Take care.
Clifton M. Bean
Informix DBA / AIX System Admin
Currency Technics & Metrics
Phone: (972) 812-1411 x244
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ART
KAGEL, BLOOMBERG/ 731 LEXIN
Sent: Wednesday, October 17, 2007 10:28 AM
To: ids@iiug.org
Subject: CP1252?Q52=65=3A=44=62=73=70=61=63=65=73=20=79.... [10172]
Only be parsing through the message log (MSGPATH)
Art S. Kagel
----- Original Message -----
From: Juan Pablo <ids@iiug.org>
To: ids@iiug.org
At: 10/17 11:15:00
Hi all:
Is it possible to see the creation date of DBSPACES and CHUNKS.
Thank you
_________________________________________________________________
Windows Live Messenger, la nueva generación de tu MSN.
http://imagine-msn.com/minisites/messenger/default.aspx?locale=es-ar
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape