Search results

Thank u all. I able to run commands now, previously i not able to run due to permission issue. My windows team not provided Administrator access to the server.

Hi All, When i try to run below commands on Windows server i am receiving this error. proutil dbname -C busy "" cannot find or open file \dbapth\pool.db errno = 5 (43). Registry error 5 could not create teh "pool_progress" key for event viewer. ( 5175). But when i try to run below command it...

Hi Tom, We are doing this way as per client requested because application is not so critical we need to make sure all application are up and running.we are disabling the After image before backup and enabling After image after backup . But before taking backup we have Ai archive script which...

Hi, I would like to know abt AI file switch.we will follow below procedure for taking offline backup and start databases 1 ) Shutdown database 2) Ai disable 3) offline backup 4) start AI 5) Start Database Questions 1) If we take offline backup during last extent is in "busy" state" database...

Secondary brokers also called as Sql brokers. Am i wrong And also i not seen any _sql process running in our server. ps -ef | grep _sqlsrv pgresdba 37544 209960 0 10:47:42 pts/2 0:00 grep _sqlsrv when i started odbc connection i able to see m3 process running in server. pgresdba...

Hi Rob, Thanks for update.............. pgresdba 189858 1 0 01:57:36 - 0:02 /progress/91e/bin/_mprosrv /progdata/aps/crndb1/apscrn -pf /usr/wrk/pf/mai.pf -pf /tst/dba/etc/pf/apscrn.pf -H test-S apscrn -N tcp pgresdba 192608 1 0 01:57:35 - 0:01...

Hi All, I would like to know, how to check the status of Sql broker is up and running. i gone through progress and knowledge base but not able to find it. Kindly help on this. Progress Version: 9.1E OS: Unix Thanks Jack.

Your wait on semaphore numbers lack context -- is that total waits? waits per second? waits per transaction? something else Ans) we have script which run every on monthly Ang get the details of all promon Information on monthly basis.the values which I provided are average of total promon...

Hi Team, Today we found in performance reports that wait on semaphore is getting high in number. For last 3 months values as follows 810.00 , 840.. and 900.00. We will take this values on monthly basis by taking overall average value of whole month. FYI.......... -n 140 -Mn 51 -spin 200000...

Hi All, I like to know about High water extent resize.We are planning to monitor extent size growth on monthly basis and based on growth report we are planning to add new extents. I have found program to monitor extent growth using following url. Progress KB - Virtual System Table (VST) used...

Hi Tom, Thanks for update.. The commands we have in the script is prorest $dbdir/$dbname $backuppath/*dsp dsp is name of the database FYI.......... once restoration got failed i ran the script its worked fine after moving the backup from archive path to backup path. Script has no problem...

Hi All, We faced some problem I want to know what exactly the root cause of it. We have backup server restoration will happened daily using script of production backups. once backup got restored backup file move to archive path.But suddenly we received email saying restoration got...

Hi Cringer Sorry for images.but I cont provide error log files due to security. In server.log files Logging level set to 4 Log entry types activated ; DB.connect's WTA server ini//tializing. 8835 Database fsping options ; 12699 User fspadm roles ; secure admin Connected to database fsping...

Hello, Today we faced some issue in webspeed broker got down.Inside log file it showing normal shutdown but before also we found normal shutdown errors and also inside log file shows log file setting 4 and WTA initializing this type of errors I am already observed but today it showing shutdown...

Hi Rob, Thanks for quick response. Yes both are same load .bd with indexes and also we used proutil dbname -C table move. We taken backup before dumping the tables.so I think we did dump and load perfectly and also tabanalys scattering factor values reached ours expectations but we r not able...

Hi All, Last week we done dump and load activity for fue db's.After completing activity we received batch jobs run time report from batch team before and after analysis.After seeing the report we found fue jobs like restoration and application programs are running more time than the previous...

Hi All, Regarding bibufs parameter present value for our database is 300.we are planning to migrate the version from 10.2 to 11.6 Enterprise edition.During this time we are planned for bibufs parameter value for increase. So any help on how to suggest a value for bibufs or any theory or...

HI Rob, Thanks for quick update. i got some statistics for table and index from our databases and parameters. For table statistics all CRUD are zero upto 50 tables only displayed. For index statistics create fields contain 2 1 2 5 0 and reads values 42717,14773,7201 and 481...etc deletes as 2...

HI Rob, Thanks for quick update. i got some statistics for table and index one of our databases and parameters we are using.

Hi All, When I am gathering information for startup parameters from progress.some parameters I not able to understand like basetable,baseindex,tablerange size and indexrange size.what type of statistics we can collect from table and index. I gone through the previous post for basetable base...