dbexport getting an error 1

[mikemcdonough]

Greetings and Salutations,

I have not been able to use the dbexport command as described in the document:

http://www.cisco.com/univercd/cc/td/doc/product/wanbu/svplus/105/dbase/backup.htm

which states:

dbexport -c -o /informixsave stratacom

I have been getting the error:

-23101 Unable to load locale categories.

Any ideas?

Mike McDonough
Network Systems Admin
CT Communications
(704) 722-6610

 

[olded]

Mike:

It looks like dbexport is having problem finding the database. Assuming "stratacom" is your database name, try this:

dbexport stratacom -c -o /informixsave

/informixsave must be a directory that already exists and have write permissions.

Regards,

Ed

 

[mikemcdonough]

Well it turned out that I was able to run the command as root instead of being logged in as informix. This, of course, begs the question - how can informix work on the database unless the db engine is running as root. I was not the one to set up this server and I suppose i should start with a freash install now that I have the database extracted. Thanks for your support.

 

[szabogabor]

Generally you must set CLIENT_LOCALE and DB_LOCALE
(see GLS Functionality Guide) in the shell environment
when you get 23101.
dbexport has to export your database data to ASCII, so
it needs your locale information.

Regarding who can run the command:
"You must have DBA privilege or log in as user informix to
export a database"
Regarding how the informix server can work :
You can start the engine as user root or informix.
The root owner and the sticky bit set on certain binary files,the requirements for example that informix chunk files must have informix owner and group, mode 660 , and the informix group must have only one user in it, the informix user together ensures
that the server works fine if you install it as it is written.

Regards,
Gabor