Search results for query: *

Well, when I run errpt -a, there is a message for ERRDAEMON going down and all of the databases shut down according to the db log.

It's a p660, model 6H1. Where do I find the console log?

We reboot our server every weekend using shutdown -r. For the last 2 weekends, we have come in on Monday morning to find that the server shut down, but did not reboot successfully. The console has all kinds of blinking lights and gibberish on it. At this point, we reboot it manually and it works...

Do the zombies show up as users when you Promon the database? If so, you can kill them there.

Polani, We had a similar problem on AIX 4.3.3, with Progress 9.1C. We had a lot of <defunct> processes when we did "ps -ef." To solve the problem, we now run a script from the crontab to shut down all databases and reboot every Monday morning at 4:00AM. I recommend calling IBM Software...

bjverzal, What is the name of the upgrade guide? Thanks, Natalie

Due to the fact that IBM is not going to support AIX 4.3.3 much longer, we are being forced to upgrade to AIX 5.1 or 5.2. This will require that we also upgrade to Progress 9.1D Enterprise database. Has anyone run into any problems doing this? Thanks! Natalie

I would bet my life that I had su'd to root when I edited the crontab, but I could be wrong. I always su to root when I'm on this server. I just edited it again as root. I didn't change anything, but I saved it again from root. We'll see on Monday morning if the script runs. Have a good...

This script works from crontab and sends the email from root: df -k>fs.txt mail -s FileSystems -c &quot;email1@lala.com email2@email.com&quot; email3@email.com<fs.txt This one doesn't, but when I run it manually, it sends the email from system: cp /tmp/ONLINEBKUP /u/bin/ONLINEBKUP mail -s...

0 23 * * 1-5 /u/bin/onlinebkup2.sh 0 8 * * 1-5 /u/bin/backrept2.sh The first one works, the 2nd doesn't. However, I can manually run backrept2.sh just fine. It's a script that emails me a file. One point is that it emails me from the login of 'system', whereas another script in the crontab...

Hello. I edited our crontab using &quot;crontab -e&quot;. I changed 2 lines. One works, and one doesn't. Does anyone know why? Thanks, Natalie

Have you tried referencing the .p or .w instead of the .r? Also, you may want to reference an .ini file (-ini filename.ini) which lists the propath for the instance of Progress. Make sure the first folder in the propath is the folder where the .r is. &quot;c:\program...

Thank you for your response. It's very informative. I hope you can answer a few more questions. Where does the Java come in? I understand the Progress, TSQL, and DTS (we use all of those currently). Also, can you explain your Queue table a little more? What data is kept there? I'm thinking the...

Has anyone had to deal with HIPAA? We just got word that we have to be able to accept 237's by Oct. 16th. (Don't ask.) I need to implement this quickly. Does anyone have a file layout or a create table statement for creating a HIPAA 237 table? Thanks! Natalie

To date, we have been importing the entire Progress DB into SQL Server every night. This process is now taking over 12 hours. We are looking into replicating our Progress DB into our SQL Server data warehouse in real time. We are researching the following: SonicMQ (messaging) PeerDirect A warm...

I'm developing a dialog that contains frames. Depending on a certain parameter, one will be shown and the other will be hidden. Only one will show at a time. I'm fine with the HIDE and SHOW syntax in the code. My problem is that I can't design both frames on one dialog!!! How do I design this...

We will be receiving a file daily from a client that we need to import into Progress. Unfortunately, it's in Excel. I need to automate the process of saving the file as a csv so that this import can be run with as little input as possible from the user. From our Progress application, I would...

Hello, I'm very new to UNIX and have inherited the task of importing monthly data from a 3490 magnetic cartridge to an AIX 4.3.3 server. There are 4 files on each cartridge. The trick is that each file has a different block size. (I have contacted the client and they say that that's the only...

The TODAY equivalent for SQL server is getdate(): month(&quot;tablename&quot;.&quot;date&quot;) = month(getdate()) Hope this helps! Natalie

Not sure if this will help, but there are 2 sp's I find invaluable: sp_mstablespace [tablename] and sp_spaceused http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_sa-sz_0kro.asp The sp_mstablespace is undocumented, but if you search it in Google, you'll find a...