Hi
We run Progress 9.1d on linux machines.
The other day in the 3 text fields of a database record we came across these pieces of text.
"7c80252d kernel32.dll" "WaitForSingleObject" "NtReplyWaitReceivePortEx "
The data recorded in the fields is added via an internal Progress process, so...
Thanks for the reply Tom,
I worked it out in the end.
We were under the pump a bit so I was after all the help I could get with this one.
Works a treat.
Thanks again.
regards
Ken
The batch process are purely to control what is sent via ftp or to run a remote unix command. The 5 main processes check the status of a request held in a table, so as to know which child to kick off. ie a data extract process or a communication process etc. thus guaranteeing a successfull comms...
Hi Tamhas,
The only person user is an admin user. The server is used to talk to multiple servers (handling ingoing and outgoing batch transaction files. The spawned processes run rexec and ftp commands to linux boxes which are triggered by another server via mqseries. 5 main batch processes...
How does one reset a database sequence?
I have cleaned data out of a database using proutil truncate and would like to set all sequences back to 0.
regards
Ken
You could look running your os commands via sudo if there are permission problems with some commands.
sudo allows you to run defined commands/programs or scripts as another user (ie root). Your administrator would need to allow whatever it is you are running.
regards
Ken
Hi debtco,
Have you thought of creating a service for your databases?
We use Redhat, and have a service created for starting our 6 databases.
It makes life easy as you can specify the dbs to start last on boot up and first on shutdown. Allows you to stop, start and get status of the dbs using...
I agree with Casper, the databases should not be crashing. Ours run day in day out and never crash. Perhaps some form of notification may be the answer. Create a cron job to monitor the database is up. If not it can alert you by email that the database is down. It could check every minute. You...
Hi,
can anyone share some simple C code showing how to connect to a Progress database on linux. ie connect, query and disconnect.
I have been able to use the JDBC however I need to do the same but in C.
thanks
Ken :confused:
Of course you could always write a simple procedure to go through each DICTDB._file except the ones you need left in tact, and delete the records :rolleyes:
Ken
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.