Error with TBLspace

I ran an oncheck -cD on a database and it comes back with this: Error opening TBLspace ps_sls_rpt_ext_cs. Since it is a test system, it isn't backed up frequently. I want to do a dbexport on this database. Can I unload the data to a file and drop the table and see if it continues, or is there a simpler way to fix the TBLspace? Keith Schleicher IT Database Administrator B2-253B-A Office: 847-286-4027 Cell: 224-210-8358 Blackberry: 2242108358@messaging.sprintpcs.com Page: 2242108358@sprint.skytel.com

I would suggest that the server (or its storage anyway) MAY have become unstable for some reason and would further suggest that you take a complete dbexport of all of the databases on that server for safety as soon as possible and consider rebuilding the server from scratch. Certainly you have to determine whether there is physical or logical damage to your disk subsystems and repair or replace them. If you can select from this particular table, I would suggest that the first thing you do is: UNLOAD TO "ps_sls_rpt_ext_cs.unl" SELECT * FROM ps_sls_rpt_ext_cs; before you even attempt the more complete dbexport. Second try to determine why the table is unreadable by oncheck and try to rectify that. Perhaps its only a permissions problem (some ham fingered SA 'fixed' the privileges on your chunk devices, etc.). If you cannot currently select from the table inside dbaccess , then the dbexport will likely fail and you will have to manually UNLOAD each table in the database except for this one. You will find some sample awk scripts in my package utils2_ak that can help you create an unload script for the tables quickly from dbschema or myschema output. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Oct 29, 2009 at 10:04 PM, Schleicher, Keith < Keith.Schleicher@searshc.com> wrote: > I ran an oncheck -cD on a database and it comes back with this: > > Error opening TBLspace ps_sls_rpt_ext_cs. > > Since it is a test system, it isn't backed up frequently. I want to do > a dbexport on this database. Can I unload the data to a file and drop > the table and see if it continues, or is there a simpler way to fix the > TBLspace? > > Keith Schleicher > IT Database Administrator > B2-253B-A > Office: 847-286-4027 > Cell: 224-210-8358 > Blackberry: 2242108358@messaging.sprintpcs.com > Page: 2242108358@sprint.skytel.com > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015173fe52af6a7e9047727f85b