Should put this in development section but see below. (cant ever seem to get formatting correct on the forum)
RUN program.p(INPUT SomeVariable,
INPUT SomeOtherVariable,
OUTPUT SomeOutputVariable) NO-ERROR.
Step 1. Create new type 2 storage area's.
Step 2. Dump data to .d
Step 3. Load data from .d into new storage area's.
Advantages.
No Physical table fragmentation. (So less need to dump and load)
1. Set up a group of .bats on your DB server to do the individual/group of tasks you want to do. IE proshut bla etc etc.
2. Use powershell to remotely execute the .bat you need. (As long as your remote machine is on the same network/vpn. If you can UNC you will be fine)
Invoke-Command should...
I doubt the issue lies with any progress code then, unless its sloppy transactions.
Are you getting return values out of the webservice? (IE the code on the appserver is finishing its execution correctly)
What are your ubroker properties set at for max client instances?
maxClientInstance...
Unless i missed something glaringly obvious because i haven't had my energy drink yet :-
This isn't connecting to an appserver. Its just setting some external P code as a handle within the current session (So wont spawn a new session).
Are you connecting via a webspeed broker and running...
Can i pretend to be Tom?
"ProTop displays all this information. It is such an amazing tool for finding out statistics about your database. It works on any device and even offers a free version."
Or if you dont feel like downloading this pretty critical tool that you should already have, promon...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.