Re: Adding dbspace/chunks with onspaces

> spot. The file created OK - onspaces claimed it didn't exist. I can > also open and edit in the same command line box, no problem It should be a Windows security-related problem. Did you try to create file as LOCAL informix user as I suggested? Not a domain user... Look, I just tried: copy nul \\\\creator\\exchange\\chunk.dat C:\\Program Files\\Informix>onspaces -c -d tempdbs -p \\\\creator\\exchange\\chunk.dat -o 0 -s 10000 ... C:\\Program Files\\Informix>onstat -d Informix Dynamic Server Version 9.30.TC2 -- On-Line -- Up 00:04:31 -- 25472 Kbytes Dbspaces address number flags fchunk nchunks flags owner name c9e27d0 1 0x1 1 1 N informix rootdbs ca37c30 2 0x8001 2 1 N S informix sbspace ca37d78 3 0x1 3 1 N informix workdbs ca37ec0 4 0x11 4 1 N B informix blobdbs cde6120 5 0x1 5 1 N informix tempdbs 5 active, 2047 maximum Note: For BLOB chunks, the number of free pages shown is out of date. Run 'onstat -d update' for current stats. Chunks address chk/dbs offset size free bpages flags pathname c9e2918 1 1 0 12800 5413 PO- C:\\IFMXDATA\\ol_creato r\\rootdbs_dat.000 ca377f8 2 2 0 12500 11005 11605 POS c:\\IFMXDATA\\ol_creato r\\sbspace_dat.000 Metadata 842 544 842 ca37960 3 3 0 25000 24247 PO- c:\\IFMXDATA\\ol_creato r\\workdbs_dat.000 ca37ac8 4 4 0 2500 ~2500 2500 POB c:\\IFMXDATA\\ol_creato r\\blobdbs_dat.000 cde6268 5 5 0 2500 2447 PO- \\\\creator\\exchange\\ch unk.dat 5 active, 2047 maximum It's a real screenshot. Yes, I am using totally unsupported XP Professional, and \\\\creator is my local hostname, and my Informix version is different, but I am sure your problem is with Windows permissions and access rights ONLY. UNC can be used in file names - only OS knows what to do with them, it's not an Informix problem at all.

Ah - you were right - it was a permissions issue. Suddenly struck me that we're running informix as a service on NT - and I've had kind of linked issues with SQLServer using resources on other kit. The service was logging in as a machine local account - and onspaces obviously uses the account logged in to run the informix service - NOT the user you're logged in as - for it's permissions. As you can't assign permissions to local accounts on other machines - I just made sure that <domain>\\informix had appropriate admin rights on the server - and used that as the service login. It's running fine now. Thanks very much for the help and advice - much appreciated Andrew