windows-1252?Q52=65=3A=20=44=62=73=70=61=63=65=73=

That would be 'el two date' (l2date) not 'twelve date' (12date) should be: select name, l2date(created) from sysdbstab; Art S. Kagel ----- Original Message ----- From: Long Nguyen <ids@iiug.org> To: ids@iiug.org At: 11/07 19:52:27 Run "select name, 12date(created) from sysdbstab" I get 201 syntax error. "select name, created from sysdbstab" will show "name rootdbs - created 1094010659". The field"created" is an integer field. How do we convert its value to a date value? Regards, Long N. ======================= "Philippe Pignon1" To: ids@iiug.org <philippe.pignon@ cc: fr.ibm.com> Subject: Re: Dbspaces y Chunks [10178] Sent by: ids-bounces@iiug. org 18/10/2007 02:40 AM Please respond to ids For the dbspaces : database sysmaster; select name,l2date(created) from sysdbstab; ________________________________ = "Juan Pablo" = <in4mixperu@hotma = il.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Dbspaces y Chunks [10171] = 17/10/2007 17:14 = = = Please respond to = ids@iiug.org = = = Hi all: Is it possible to see the creation date of DBSPACES and CHUNKS. Thank you _________________________________________________________________ Windows Live Messenger, la nueva generaci=F3n de tu MSN. http://imagine-msn.com/minisites/messenger/default.aspx?locale=3Des-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. Disclaimer: This correspondence is for the named person's use only. It may contain confidential or legally privileged information or both. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this correspondence in error, please immediately delete it together with any attachments from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient. Any opinions expressed in this message are those of the individual sender, except where the sender expressly, and with authority, states them to be the opinions of Ruralco Holdings Limited or any of its subsidiaries (collectively "Ruralco"). Although all care has been taken to screen this communication for viruses, neither the sender nor Ruralco warrants that any communication via the Internet is free of errors, viruses, interception or interference. Information is distributed without warranties of any kind. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Question: We have a system catalog tables (syscolumns, sysviews, and systabauth to name a few...), that are currently (> 140) extents. Should we be concerned and reduce their extents? If so, should we: 1. drop and re-create the application database(s) and export/import data or 2. drop and re-create the sysmaster database using buildsmi on the sysmaster. This is for version 9.2x and higher. Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " **************************************