Search results

Oh okay. Thanks for the explanation. As am not using Progress Editor much; I am not used to this. :)

Not sure if this is to do something with configuration - when I do a Ctrl + F and search for a word in a .p file that is opened in Piew it highlights the first occurrence and takes me to the place but the dialog box gets closed. If I had to search the next occurrence I got to press Ctrl + F...

Thanks Stefan for your response. My bad - Yes this works. Can you pls. check the below one? - this doesn't {sample2.i &t2_lock = NO-LOCK /* &test = yes */ } Now it doesn't. My Listing file looks weird too; {} Line Blk -- ---- --- 1 2 {sample2.i 3...

OE 11.6 - Let's say I have a program sample.i which has below code snippet; &IF DEFINED(test) = 2 &THEN message "{&test}" view-as alert-box. &ENDIF. Now when I run below code; - let's say test.p {sample.i /* &test = yes */ } Ideally I would not expect the message statement to be...

Yes Rob, we are under CBP model.

@Rob Fitzpatrick @TomBascom @RealHeavyDude @cj_brandt - I agree to the comments that are been provided. Let me give the background of why my client need this. They have currently 200 user licenses and after migration looks like the number of users are going to increase more than 200 but at any...

Self Service. We do SSH to the Unix Box using Putty and connect to the DB that resides on the same box using a wrapper script that runs mpro command. We are looking for an option where we can find users who are not using the application (not even navigating the UI), say may have left it open at...

Do we have a client timeout parameter in 9.1E (Unix) and 11.6 (Linux) from progress side? My requirement is if a user is not active for more than 1 hour I have to kick out that 'mprof' session. We use Putty to connect. Do I need to use time out option on putty? - not sure if that will end the...

Good option to have; had a glance at the ppt and would love to try when I have sometime. Sadly on 9.1E and doing all circus to move to 11.6 (easy to deal with technology but with people at meetings ;) :oops:)

Yes Rob, my proposal is to categorize the 950+ tables into different areas based on size where big and medium size tables will merit separate area. If they agree for that approach am sure we will have to do D&L and we can't go with PROUTIL CONV utility. Is my understanding right? But after all...

@Rob Fitzpatrick - We haven't taken a call on that yet. I am testing both approaches on our test machine right now. As you pointed out if it's just D&L we can skip DL for this 2 tables (just have to make sure we don't get into dependency issues with downstream applications) but if we have to...

If we end up migrating this table, as per the current strategy this table will be loaded into separate area and can be truncated. But the plan is to perform cleanup on 9.1E and give it 2 or 3 weeks in production to make sure we don't see any impact in terms of functionality and then start the...

This application will be migrated to 11.6, right now it has 2 TB size of db but by doing this cleanup operation eventually we can bring it down to 1.2 TB which is what we are aiming at in 9.1E and doing this will make our life easy during migration process as we will have only 48 hours of...

yes Rob, that's the plan for small/medium ones. But we have 2 big tables (close to 100 GB) on different area that are bothering us which is currently clubbed with other bigger tables (around 50 GB) on the same area. Let's say; Area 1 - T1 (50 GB), T2 (100 GB), T3 (25 GB), t4 (60 GB) [in which...

I agree, but it's an old application and the tables/area categorization are messed up. We have a list of tables that are not in use and need to delete (all of them are not on separate area); the ones in separate area as you said we will use TRUNCATE for sure.

@Rob Fitzpatrick - I tried in 11.6 yesterday and I was able to drop tables using sqlexp but not on 9.1E. Not sure if that's an expected restriction - but the error message seem to be so.

Got it! Thanks Rob.

Excellent explanation. Yes Rob, it's Type II areas. Sorry, should have mentioned it before. Quick question - Let's take a case I have 4 tables in an area where t1 is 40GB, t2 is 30 GB, t3 is 60 GB and t4 is 10 GB. Let's say I delete table 't3'. When you say I have to dump and load it's still I...

Progress Version: 9.1E I am not able to delete tables using SQLEXP and getting the below error. Can't I use SQLEXP in this case and rely on incremental DF to drop the 2 tables (close to 100 GB each)? Incremental DF takes around 7 minutes to delete these 2 tables. === SQL Exception 1 ===...