I've migrated a 9.1.0.2 database to Viper 2 Beta... everything seems to have worked - I can connect to, and query my database as normal.
But, now I cannot enable the database for NSE. Everytime I issue the ENABLE TEXT command I get the following: codedb2text "ENABLE DATABASE FOR TEXT CONNECT TO db"
CTE0190 Executable program "cteadmsv" could not be started.[/code]I've tried executing cteadmsv directly, and it runs without reporting any errors. I've checked the db2diag log, and there seems to be nothing relevant appearing there...
So can anyone give me any information at all on the cteadmsv program?! It does not turn up anything when searching on ibm.com
A strace suggests that cteadmsv is trying to retrieve a message to display from the "/home/db2inst1/sqllib/msg/en_US.iso88591/cteadm.mo" file. Indeed, cteadmsv is returning 1, which would indicate an error condition, but nothing is output to either stdout or stderr. And nothing is being added to the db2diag log. It is simply returning 1 with no output.
Is there no-one in IBM that reads these forums that knows anything about db2text / NSE? I never get any replies when I ask about NSE stuff :( Although I've ask before, I'll ask again... is there a more appropriate forum for NSE questions somewhere?
Don't know much about NSE... just thought I ask if you ran the migration commands for NSE databases. There is a migration task that has the details:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.admin.nse.topics.doc/doc/t0052133.html
At eGA this task will be revised because you need to do step 6 before step 4.
Hope this helps,
> just thought I ask if
> you ran the migration commands for NSE databases.
Yep, I've been there, and performed those steps up to 4.
> At eGA this task will be revised because you need to
> do step 6 before step 4.
Ok. So I jumped ahead and did step 6 - worked as expected. But still, going back to step 4, the "db2extmdb" command fails because "The database is not enabled for text". And, as usual, when I try to enable the database for text, I get the "cannot execute cteadmsv" error still :(
Any other ideas?
Is there some way I can diagnose the problem with "cteadmsv"? It looks to me (strace) like the program is not even being executed by the db2text command.
Hi,
I assume you are working on a Unix system. This problems seems to be caused by having two separate user ids for the instance owner and fenced user id. These user ids should be in the same primary group. To check this change to directory ~/sqllib/adm and do a ls -al on .fenced. If the group of .fenced differs from the primary group of the instance owner there is a work around: remove the .fenced file and do a touch so it has the correct ownerships. The actual solution is to create a DB2 instance with user ids that belong to the same primary group. I hope this helps.
Regards,
Thomas
I checked out the persmission as you suggested but to no avail :(
However, I've got it working now!! It ended up being a shared memory (or lack thereof) issue... it's a pity nothing (no error messages, nor any log files) could tell me that :|
In case others find this thread like I did, this error does seem to be memory related.
In my case changing JAVA_HEAP_SZ from 2000 to 50000 did the trick...
... unless it was the server bounce that I did for the dbm configuration change to take effect.
In either case, I still got this error on a GA DB2 9.5 right after the NSE install.
Tags
Use the search field to
find all types of content in My developerWorks with that tag.
Use the slider bar to see more or fewer tags.
Popular tags shows the top tags for this particular type of content or application that you're viewing.
My tags shows your tags for this particular type of content or application that
you're viewing.
