Search results

  1. D

    Connect to AIX Server from Windows using ODBC

    The -n 168 will limit the total number of connections to 168 and this includes any batch jobs. This -n is number of connections and has very little relationship with how many connections you're licensed for. But, the thing that's stopping you is the -Mn 1. This says that progress can only...
  2. D

    Mfg/pro install in linux.

    In the install document for progress is specific instructions for how to mount the cdrom for the install. You should follow those instructions carefully. Also, for redhat 9 to work with progress, you will need to make sure that you have installed first the compat-libstdc++ package that allows...
  3. D

    OE 10.0 Backups and Progress Explorer

    > I'm using the _mprosrv command to start the database up after the offline which a bunch of parameters like -S -N -L -B -n -Mn and so on. Open progress explorer, set the configuration to match these parameters. If you don't know what a particular parameter translates to in the explorer...
  4. D

    Website communication

    You want to look in the knowledge base for the solution that allows you to use sockets to communicate with a web server. Basically, you want to open a socket to a webserver and write the stream of data to it and read the return stream from it. If you've never used sockets before, you'll have...
  5. D

    OE 10.0 Backups and Progress Explorer

    You should look into doing online backups removing the need to stop and start the db for nightly backups. To answer your question, you use the commandline dbman -db dbname -start to start the database through the admin server and progress explorer will recognize that it is running. So, modify...
  6. D

    Efficiency...

    Mostly I agree with you Joey, and I make the same argument that indexing on a logical field doesn't usually make a lot of sense, but... In the case where 98% of your records are no, and you really want to filter to the yes records, an index on a logical field can be a very efficient way to do...
  7. D

    Help Me.........

    We'd like to help with this, but you can't say the sites are all the same. You have to find the difference. I'm assuming you are transferring a file to the location and at that location are running some form of import which happens in 30 minutes at all the sites but one where it takes 4...
  8. D

    WebSpeed and Firewalls

    Choices.... You can have progress installed on the webserver in the dmz and start the broker there, in which case you need to open the ports you mention to establish remote client/server db connections. Perhaps a better solution is to not install progress at all on the windows IIS server, but...
  9. D

    Help, OS limited.

    In what way did the machine hang? Did you use different filenames for the second db? Is the second db running or not? I'm not sure about online backups in 8.3. What size are the db's you want to backup, and how much disk space do you have in the backup target location? What block size are...
  10. D

    DB is damn slow during the backup

    As Progress_Guy points out, there are several things which affect this, but the thing I think first is that you shouldn't be doing backups during performance sensitive times. If you need data integrity, then twice a day isn't going to do it for you anyways. What you'll eventually want to do is...
  11. D

    Help, OS limited.

    Check out the -vs param. probkup dbname dbname.01.bak -vs db_blocks_per_output_file It will prompt for the next file name after it writes db_blocks_per_output_file blocks. ie, if you have 8k db and you use -vs 220000, then the dbname.01.bak file will be (about?) 1,760,000 ... Hope that...
  12. D

    OpenEdge Studio 10.0b (Error 8336) no KB fixes work

    Progress explorer communicates directly with the Admin service. The progress explorer tool also needs to match the Admin service to the patch level in order for that communication to work effectively. ie, if you have OE 10b02 on linux, you have to have oe10b02 on windows for it to work. This...
  13. D

    Progress with JDK1.5

    Since it is very possible for your linux system to run just fine with multiple java versions installed, and since only a specific version of java is supported by progress, why would you want to run progress with the wrong java? If you need java 1.5, install it... but make sure you set your...
  14. D

    WebSpeed Agent Error: Agent did not return an HTML page (6383)

    If absolutely nothing has changed in your environment or code, then you need to restart the wtb broker at least and possibly the nameserver if you're using it. This error is telling you that the progress agent that runs on your behalf to service http requests is not returning a valid html page...
  15. D

    question regarding extent build times

    Probably want to check out this recent thread... http://www.peg.com/lists/dba/web/msg16488.html
  16. D

    lg-file/ Progress 9.1C / Windows 98

    There is the possibility that the log file has become disconnected from the running progress process. Not sure of the terminology here, but if you do something with the log file that might change the inode, or the pointer to the file from the pointer the process in memory has (like opening...
  17. D

    week number 1 - 5

    Well, it's a little obfuscated, but it will work... basically add to the day of date, the day of the week of the first month so you're counting from the first day of the first week of the month even though it's in the previous month. I subtract 2 because (1) the weekday is not zero based and...
  18. D

    Remote Access using AppBuilder 9.1D08

    You can do this. Look at the apache docs here and add the serverPath directive to allow http 1.1 non-compliant clients to access your vhost. http://httpd.apache.org/docs/2.0/vhosts/name-based.html You will need to change your appbuilder url in the setup from something like this...
  19. D

    Tuning AI and BI

    So are AI and BI writes becoming a bottleneck for db performance? How have you measured them to be a problem? Do you have the ai and bi extents on their own spindles? I'm not sure you can tune down to the level you're talking about, but I'm also not sure what useful performance gain you would...
  20. D

    probkup and compress

    On AIX, i use gzip on the files after the backup is completed and sent the total backup size from 16 Gigs to less than 3 Gigs.
Top