Search results

  1. A

    prodefault command within the sysprogess.systables_full view

    I was looking at some sysprogess views and ran across this function within the select statement "PRODEFAULT ( "_File-Number" , "_Template" , "_Field-Physpos" , "_Dtype" , "_Extent" , "_Width" , "_Decimals" , "_Owner" , "_File-Name" , "_Charset" , "_Collation" )" This code is from the...
  2. A

    Dump and Load simple question

    Hi Everyone, We recently have done some D&L on our systems, and I know that there is a benefit with gaining storage space. But I was wondering is there any other gains to doing a D&L as far as performance boost in reading records from the newly reloaded tables? Thanks,
  3. A

    Openedge 32bit running on a sparc 64bit server performance problems.

    Hi Everyone, I was wondering if anyone would happen to know why we would be seeing a performance slowdown in our progress environments. We are currently running OpenEdge 10.2A 32bit, The server we are running is a newer Sparc Sun4V with 64 bit and 32core cpu and 16gb ram. We are going to be...
  4. A

    Update a single table in mutiple databases

    Hi, I am needing to update my _user table accross mutiple of db's. I have tried disconnecting from all the db's and then connecting individual db's but that seems to only update the first db that was connected. So for example, if I have the following databases: 1: System 2: Locations 3...
  5. A

    Login issue within a shell script

    Hi, I was looking to have some ideas on how I can get this connection working: I have a Unix shell script that runs a .pf file, but I was looking to have the username from the unix system assigned to the -U parameter within the pf file. Sample of my unix script (Excerpt): DBS=/dba/db...
  6. A

    Variable Extents using the max growth threshold

    Hi, Just a quick and pretty simple question. from the Progress DBA guide for 10.2 " While you indicate a variable-length extent by leaving out the extent size in the .st file entry line, you can also specify the maximum size to which the extent can grow by indicating the “v” extent type and a...
Top