Search results

  1. M

    Relocate Extend Online

    The extend are already exsit in the database location. We need to distribute it to multiple drives as it was before. d "Schema Area":6,32;1 /db/production/production.d1 # d "Data Area 1":7,64;512 /db/production/production_7.d1 f 1048576 d "Data Area 1":7,64;512 /db/production/production_7.d2 #...
  2. M

    PRROWID Pro2 Replication

    The Bulk data (1000-m records approx) need to load into the target Oracle database. It needs to be handled via ETl. Once data loaded we need to sync up with Pro2 the same value will patch the table. The PRROWID Column doesn't exist in Source Progress side. Question: When the pro2 replicates...
  3. M

    Table size in Progress DB

    Hi, Check the Table size in the Progress 4GL database. Is there any commends it would be really helpful full to find the table size in GB. Thank you
  4. M

    PROMON Record Locking Table

    PROMON Record Locking Table There are many locks waits. Did we get the chance to export a report for the report from Proenv session ?
  5. M

    Target restore failed

    While restoring getting below error: We have sufficient .st file and .d file. Tried with different direct path to restore getting the same error. Source backup: probkup online sports2000 R\sports2000_target.bkp -REPLTargetCreation target restore: prorest S:\databases\ob30\sports2000\sports2000...
  6. M

    multi-user mode. (276)

    While adding st file getting an below error. It is possible to add without stopping the database ? If so, please let me know the steps, thanks. prostrct add sports2000 addai.st OpenEdge Release 11.7.4 as of Wed Oct 10 19:02:14 EDT 2018 ** The database sports2000 is in use in multi-user mode. (276)
  7. M

    enableSiteReplication target Issue

    I have enabled the Replication on source and up & running source. While enabling to target Dr getting an below error. Proutil sports2000 -C enableSiteReplication target OpenEdge Release 11.7.4 as of Wed Oct 10 19:02:14 EDT 2018 Replication (target) cannot be enabled on a database that has not...
  8. M

    switch over and switch DR

    How to switch over and switch back Progress database 11 1. Current process 2. Using Replication Set 3. Does 2 have any advantages over 1. Does 2 help in transition to avoid reseeding of the database.
  9. M

    Unable to connect the sql

    I'm getting the error while login to the SQL using sqlexp. Error: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Remote Database Name not valid.. (8933). Seems DB is correct only. Kindly provide any suggestions.
  10. M

    Index activation online and offline

    Activates an index online and offline databases. What is the different between online and offline. Generally we used the below. proutil db-name -C idxactivate table-name.index-name Please provide the syntax for both online and offline.
  11. M

    Question Loading DF (.df's) File in Progress via Proenv or cmd

    loading database definitions (.df's) using Proenv or cmd, This is needed to be automated hence we are using this to load the DF, In Ex: Data definitions (.df) needs to be load using newly created df. The Progress DB Version 11.7.
Top