you would check the file permission or file existence by unix command as:

ls -la yourfilename

-----Original Message-----
From: bradp
[mailto:db2udbdba-ezmlmshield-x2486296.[Email address protected]
Sent: July 26, 2006 9:24 AM
To: LazyDBA Discussion
Subject: Create Table Space Error


To all,
When trying to create the following table space in a development instance
I am receiving the following error. How do I tell what file is set to read

only? I am logged in as the instance owner. I can run this same command in

the production environment with no issues.

CREATE REGULAR TABLESPACE TS_CENSUSDATA PAGESIZE 16 K MANAGED BY SYSTEM

USING ('/datafs1/TS_CENSUSDATA', '/datafs2/TS_CENSUSDATA',
'/datafs3/TS_CENSUSDATA' ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16
TRANSFERRATE 0.14 BUFFERPOOL BP16K DROPPED TABLE RECOVERY OFF;
------------------------------------------------------------------------------
CREATE REGULAR TABLESPACE TS_CENSUSDATA PAGESIZE 16 K MANAGED BY SYSTEM

USING ('/datafs1/TS_CENSUSDATA', '/datafs2/TS_CENSUSDATA',
'/datafs3/TS_CENSUSDATA' ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE 16
TRANSFERRATE 0.14 BUFFERPOOL BP16K DROPPED TABLE RECOVERY OFF
DB21034E The command was processed as an SQL statement because it was not

a
valid Command Line Processor command. During SQL processing it returned:
SQL0970N The system attempted to write to a read-only file.
SQLSTATE=55009

SQL0970N The system attempted to write to a read-only file.

Explanation:

A file used by the database is marked read-only or does not
exist. The database requires write access to this file.

The statement cannot be processed.

User Response:

Terminate the application on receipt of this message (SQLCODE).
Ensure that all database files are allowed both read and write
access. Check for unnecessary blank spaces within the specified
filename.

sqlcode : -970

sqlstate : 55009

Thank You,
Brad Peterson
Director of Information Systems
Northern Tool & Equipment Co.


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page