Recent content by casorohi

Hello everyone, I need to understand the output of dbanalys: Actually I observer one the data extent is growing very. to verify the size of tables/index in that area I run the tabanalys but in tabanalysis report the details of that storage area did not appear. Then I run the dbanalysis and the...

Hello everyone need your advice on dump and load of two diff progress versions. We have two version of progress on one machine I.e 9.1d and 102b06. Next few days the dump and load is scheduled to improve the performance for v9 db. 1. Will this work if I convert version 9 db to version 10 to...

Hello everyone, I am new to mfgpro and I want to dump the all the data for 25.3.13 to create a Cim file from one db. And upload the data in another db through cim upload. I see many example on this forum how to upload the data through cim upload under 36 option. I want to first how I'll...

Can multiple database can be monitored through one console or any drop down where to choose the another Databases !

Hi friends I need your advices on following: Actually I have database and want to do dump and load to create a new database. My doubt is if I dump the df and load the same df file into new DB. The table numbers (_file-number) are changing in new DB w.r.t old DB. For example in old DB I have...

Hi friends One of our client wants to migrate the Oracle 9i and 10g Databases to OE10 on Linux 64 BIT. Want know is there any guide lines, document, Progress KB article on this. or any one experienced migrating the Oracle DB to Progress DB. The DB size is around 150GB. Thanks

Hi all need your help in understanding, which one data type would be more and best between two I.e integer or Boolean in following case. Actually the required new table has 14 fields, out of which six fields value would be 0 or 1 (interger). Want to know if we opt the Boolean data type...

Hi Everyone need your help, how to get the table record count. Actually there is requirement that I have to check the record count for few table and compare with a standers value twice a day. Now I want to know which one is the best and fastest way to do: Record count through 4GL Records...

How to tackle these two scenario/Index: 1) ADD INDEX "idx_brochure_date " ON "brochure" AREA "bpr_idx" INDEX-FIELD "brochure_id" ASCENDING INDEX-FIELD "no_of_days" ASCENDING INDEX-FIELD "price_start" ASCENDING INDEX-FIELD "dcs_excep_type" ASCENDING UPDATE PRIMARY INDEX...

Hi everyone need a help regarding schema upload (.df) through cmd line and want to run the job/process in background. Actually a new index needs to be created on table size 60.6 GB, so when I update the schema through datadictèADIM è load df . it start successfully but after some the...

Thanks a lot for help... another dount how to check the OS block size ?? Thanks caso

Thanks Rob So waht I under stand for eg: at 4K block size DB with mean value = 185 Now the calculation for 8K block will be: 8192 / (100 + 185) = 28.7 ; next power of 2 is aprox 56 and; for this RBP = 64 is this correct ?? Thanks

Hi all need your expert advice on RPB. We have OE 10.1A DB with 4K block on HPUX and we are planning to do dump and load soon for type-II conversion. In the same time we are also planning to change to DB block to 8K In this case how we calculate the RPB for 8K, where we have mean value of 4K ...

Thanks RHD :) one more help how to connect to more than DB using sqlexp utilities ? Thanks

Hi need a help on accessing data from VIEW a through ODBC/JDBC. I am created a view through PROGRESS editor and able to access/see the data of VIEW through PROGRESS editor. But when I login to through ODBC/JDBC/SQLEXP, I am not able to see the VIEW that I created under user sysprogress and...