Search results

Not sure if I understood completely - sorry for that. The time that I have mentioned is not for running the entire code snippet; it's only for the below part of code; I checked with both profiler and by adding etime.

I understand not many will be using tight loop with 10k iterations but we have got few scenarios of this kind (and even if we consider a case with less number of iteration the function consumes 3+ times more than the operator). [in our application in this scenario the concatenated string can...

Code Snippet: assign vFileName = 'mytest_' + replace(string(mtime),',','') v-data = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'. run profiler/on.p(vFileName). DO i = 1 TO 9999: v-tmpdata = SUBSTITUTE(lcBaseString,v-tmpdata,"~n",v-data). /* v-tmpdata = v-tmpdata + "~n" +...

I think I wasn't clear about that - sorry @cj_brandt We have 2 app's; first app - 300 GB (running currently on 9.1E) second app - ~2 TB (running currently on 9.1E without any issues but will be migrated to 11.6 next weekend; we have completed 3 rounds of test cycle and we are good with it)...

Sorry Tom. In most of my db related threads I start with progress version and OS these days. I thought I mentioned it already - my fault.

I have identified the issue. Just thought of sharing with you - but I don't have a proper explanation to this right now and if anyone has please share. This is a small old app (300 GB) that is still running on 9.1E version of progress, we will be migrating this app once we are done with the...

Not sure if I understood this part but RETRY will resolve the time stamp issue.

May be a dumb question but would like to have an explanation to my scenario so that I understand it better. Let's consider we have a source db and a hotspare db; Scenario 1: 1. Truncate the source BI 2. Use probkup to back up the source db or use mark backedup 3. Begin AI on source DB which...

AFAIK, you need temp-tables to achieve this in progress.

Excited!! Registered for PAS & Performance Take 2.

Awesome @TomBascom! Just couple of line of code changes and the report showed the issue in the very first line. In the ppt slide# 27 - I guess it should be {profiler/on.i "batch001"} & {profiler/off.i "batch001"}.

Progress Version: 11.6 OS: Linux CentOS7 I am aware that we have a tab on PDSOE dedicated for Profiler but would like to know how to use the same in Linux. Can you please point me to some documentation for the same?

I came across one such scenario today. It happens on unnamed frames; it didn't throw error until x(78). If I provide anything more that that compiling the program as batch process (_progres -b or mbpro) throws error whereas mpro doesn't. Why? Below is a simple 2 liner program that would...

That's awesome. Thanks @Rob Fitzpatrick...

Version: 11.6 OS: Linux CentOS7 I created couple of users and grant permission for few tables using sqlexp. How do I check if the privileges are set properly? I tried querying 'USER_TAB_PRIVS' view but it threw error saying; === SQL Exception 1 === SQLState=42S02 ErrorCode=-210083...

@TomBascom Very true, these are the stuffs that I keep hearing from them during our meetings. I will get them into a call tomorrow for further discussion on the same. Thanks Tom.

When I tested on Internal SSD's, restore took 2.8 hrs and OS copy option took under 1 hour. As you have pointed out if they are fine with using internal ssd's I will not be facing this issue at all but here they want the prod to be on iscsi san and non prod env on netapp (being a consultant I...

OMG! I would love to stick with probkup/prorest if this happens in our system rather than those hassles. Is there any tool where I can monitor this during a restore and collect statistics to present the data to admin team?

@TomBascom Very true, I totally agree with it.

The plan for us is to have our prod db in pure array and rest of the environments on netapp. Our db size is roughly around 1.3 TB. 2 rounds of migration testing is completed and the statistics that I provide are from that test. Please don't mind me asking this Tom, just wanted to know based on...