Rocket® U2 | UniVerse & UniData®

I'm developing a subroutine that will copy a record from one file to another.Depending on the value of one of the input arguments, the target record will be overwritten if it already exists in the target file.Upon confirmation of a successful copy, and depending on the value of another input argument, the source record could potentially be deleted.I'm looking for methods of confirming the copy was successful; i.e., the target record is identical to the source record.Any suggestions?------------------------------Shawn WaldieManager, Enterprise Application DevelopmentRocket Forum Shared AccountLos Angeles CA US------------------------------

We will soon upgrade UV storage to solid state.  A couple times in my life I've seen fast I/O bring unanticipated timing issues when file updates happen sooner than anticipated by the application design.  I'm struggling to remember details.  One was a multi-write logical transaction where, at some point, some files were moved to a much faster disk or bus than the others, so the writes got temporarily out of synch, creating unanticipated confusion for nearly simultaneous queries.  It wasn't a problem when everything was slower. Would anyone care to share any such gotchas they've seen, particularly when moving to solid state storage? (It does seem an odd thing to complain about:  my system is too fast.)------------------------------Chuck StevensonDBA / SW DeveloperPomeroyUS------------------------------

We utilize 4 connection pools used by our Web Service calls.  Occasionally we have had web services timing out and not even reaching our U2 programs.  I was hoping for some ideas on how we might  check the connection pools to determine when they are overly busy, or calls are backing up/timing out.  We have not found a way to determine this.  Our web team contacts us when their calls are failing and we must dig around looking for a problem.  Hoping there might be some "tools" that would specifically target the health of the connection pools.------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

When working in Unidata, I was able to toggle on a display of each executed line as they were executed. What is the equivalent command in Universe please?In Unidata at the debugger command, I would type 'V' to view source before executing the line. In Universe, I can type I or L to show the source line (or Z to display the next 10), but this isn't a toggle. It only does the one line you are on it seems. In Unidata, once the V was toggled 'on', I could do a command to execute the next 50 instructions and would see the source of each line for those 50.  So my question is, how can I see the source for each line executed without typing in the 'L' at every line? Thanks!!------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

Hi allI'm trying to work with a session pool in uopy and I'd like to be able to switch between different sessions as it can be done using the command ic_setsession in the uvic32.dll API.I create them in this fashion: sesiones = [] for i in range(10): sesiones.append( uopy.connect(host='...', user='...', password='...', account='...', encoding='cp850', service=uopy.UV_SERVICE, port=31438)) Is there a way to do this?How can I make sesiones[i] the active session at will?------------------------------Hector CortigueraRocket Forum Shared Account------------------------------

The Rocket MultiValue R&D team understands your applications depend on a stable, high-quality version of UniVerse as you plan upgrades and enhancements to your application(s). To incorporate customer application testing, we are extending our UniVerse 12.2.1 quality assurance (QA) cycle. UniVerse 12.2.1  will be worth the wait and will include: UV BASIC profiling for application performance analysis and insight to help you quickly determine bottlenecks and performance improvement areas in your BASIC code A 3rd mode allowing you to run with the system buffer off and in single-process mode 50+ enhancements 150+ bug fixes Our plan is to complete QA near the end of July and release on August 30th.------------------------------Christine RizzaMV Product ManagerRocket Softwarecrizza@rocketsoftware.com------------------------------

We have a behavior that we have been trying to track down for quite some time and it keeps flaring up.We are on AIX 7.1, Unidata 8.2.2, but also does it on 7.3.3We have nfa connections that will create thousands of these processes "nfauser 29753982 13697148 14 19:28:43 - 0:01 udtsvr -u -o/usr/ud/tmp" A single nfauser connection or a couple of the same will start up remotely, reaching over to another server via a nfa FX pointer. Normally its fine and works like it should, we have thousands of these daily at least and they are fine.  A few applications will cause it sporadically. Below is an example we were able to create that does it, though I had to run 3 or more at once to get it to do it:From ECL command line = "SELECT ORDY CONVO.KEYS.BAD" will trip the condition if ran 3x during testing from our system called "DP" to our "DOCK" system.:ED DICT ORDY CONVO.KEYS.BADTop of "CONVO.KEYS.BAD" in "DICT ORDY", 6 lines, 54 characters.001: V002: SUBR('GET.CONVO.KEYS.BAD',@ID)003:004: Convo.key

hello,If I want to use U2PY (not UOPY)  I do not understand what type of connection (identification/authentification) occurs ?  Is it a heritance of the current (shell) session on the server ? and by the way which uvengine is used ? (uvsh, uvapi_..., ?) .  Thanks for any detail.Manu

By storing your data in internal format in your MV database, you can easily convert the data to a desired display format.   One of the most common uses for conversion codes is dealing with dates.  In MV the internal representation of the date is an integer.   For example the internal format for "04 Dec 2014" is 17140.  Those familiar with U2 BASIC know they can get the internal format to the display date format by using the OCONV function.   I.e   PRINT OCONV(17140, "D")   The 'D' is the Date conversion code and it is used with both the ICONV function as well as the OCONV function.   With the introduction of the u2py modulo, these functions have been exposed as methods of the u2py.DynArray object. python> test = u2py.DynArray("04 Dec 2014")python> itest =  test.iconv("D")python> itest<u2py.DynArray value=b'17140'> Since the itest variable now has a date in internal format, you can use a different conversion code to get other display formats.  python> itest.oconv("D4

I remember being able to open an index file on Universe within basic and reading the records in an xref type fashion. Where I am working now isn't using indexes but rather executing multiple external selects from within a program, not ideal.Does anyone have a simple ditty showing how to open this file within the basic program? Anything special about the VOC entry for the index file?Thanks,Kathleen------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

Hi - as ive mentioned in previous threads, I just switched from unidata to universe.  A coworker mentioned a trigger but I do not see a version of my unidata commands:CREATE-TRIGGER, LIST-TRIGGER, DELETE-TRIGGERI do see the LIST.SICA command, which lists universe triggers on SQL files....do we not have triggers on regular PICK files in universe?------------------------------Kathleen HambrickProgrammer at Colwell------------------------------

I am wondering if anyone has experience with using the logs captured by U2 Audit to feed in to Azure Application Insights (or similar). It seems to me these logs would be a great source of data for visualization and analysis. If you have done this, what issues and roadblocks did you find? What tools did you use for visualization and for analysis? Thanks.------------------------------John GreenHead of TechnologyUltradata Australia Pty LtdMalvern East VIC AU------------------------------

The internal UniData lock mechanism has advantages over those used in UniVerse, so for UniVerse to benefit from those it was decided as part of UniVerse 12 that the UniVerse would use the same mechanism.This is a presentation I delivered internally to the support team here at Rocket when the UniData lock mechanism was moved into UniVerse 12. So the information is correct for UniData and for UniVerse 12 and onwards (i.e below UniVerse 12 still uses UniVere's old lock mechanism).------------------------------Jonathan Smith UniData ATSRocket Support------------------------------

hi everybody,question how to known the LOCK waiters : -- a/ session1 set a task synchronization lock  with LOCK 9   b/ session2 will set a task synchronization lock  with LOCK 9  without PROMPT NO.WAIT nor  ELSE on basic. (yes bad coding but legacy :-)then session2 is suspended until session1 UNLOCK 9 So, for admin point of view, is there a method to list 'LOCK ' waiters ?like ... session2 wait for lock 9 owned by session1  actually, my solution is to perform PORT.STATUS PORT 2  + VLIST current program + check if adress line is  the command is LOCK ... any idea ? many thanksmanu

hello,While using the release 11.x of UV if I want to start a process at the start of Universe on Windows, I'm used to define a ScheduledTask with Trigger OnEvent with a subscription like this <QueryList> <Query Id="0" Path="UniVerse"> <Select Path="UniVerse"> *[EventData[Data="UniVerse (log daemon) started"]] </Select> </Query> </QueryList>​ but, on release 12, I do not get the "UniVerse (log daemon) started" anymore , the only event I can imagine usable is <EventData> <Data> C:\\U2\\UV\\bin\\uvcleanupd.exe Uvcleanupd Daemon started by pid (11828) </Data> </EventData> ok, I must analyse the Data value in my process because EventLog Triggers use limited xpath query and do not support *[EventData[contains(Data,"Uvcleanupd Daemon started")]]Is anyone have another idea on uv/win r12 ? many thanks------------------------------Manu Fernandes------------------------------

Once the UniRPC daemon spawns either a uvcs or uvserver service and the service has established a UniVerse session, is it possible from within the session to determine if the connection is secured via SSL/TLS?The uvcs sessions run the *UOLOGIN subroutine and uvserver sessions run the *ODBCLOGIN subroutine, so there is a possibility to perform BASIC code to query the security status of the current session. I just have not found a way to determine the security status of the session.------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC Australia------------------------------

Platform: RHEL 8.5DB: Unidata 8.2.1 hf11I have a customer who is seeing this message popup on people's screens.  The process in question isn't doing much of anything but they're obviously concerned.  Any idea what causes this?(You're likely going to tell me that this needs to go through the normal support channels but the VAR that this customer bought from isn't a VAR anymore, or so we have been told.  So they're kinda orphaned.)

A fancier shell for Universe on Linux that has support for persistent history and history searching. It also has easy access to the help files through a MAN command.https://github.com/Krowemoh/NovaShellI've been use it daily for about 6 months now so hopefully its at a point where it's usable by more than just me. I use vt100 and viewpoint as my terminal type usually so that is the most tested but a few other terminal modes should work as well.Let me know if anyone has any ideas or issues, the big thing I'd like to add is color but the ANSI escape codes don't seem to work and I don't want to use the terminal codes.------------------------------Nivethan ThiyagarajahProgrammerAsynchron Systems IncToronto ON CA------------------------------

Excellent information sir, thank you.On Wed, Jun 1, 2022 at 4:00 AM Jonathan Smith via Rocket Forum wrote:> Kevin, In terms of intervals and how cleanupd works I have covered this in> several technical presentations in the past. I'd have to check to see...> Invite your colleagues to join the Rocket Forum and grow our expert> network.> ------------------------------> [image: Rocket Software] > Rocket U2 | UniVerse & UniData> > Post New Message Online> > Invite your colleagues to join the Rocket Forum and grow our expert> network. Share this link. > Re: Unidata 8.1 [AIX] - Cleanupd and Record Locks> > Reply to Group Online> > [image: Jonathan Smith]> > Jun 1, 2022 5:58 AM> Jonathan Smith> > Kevin,>> In terms of intervals and how cleanupd works I have covered this in> several technical presentations in the past. I'd have to check to see if> they are still posted on the Rocket sites. Please excuse the length of> response but this should answer all your questions.>> The cleanupd.log in the

We are getting this error when attempting to execute udt on our code depository Could not load program udt:         Dependent module /.udlibs82/libunidata.so could not be loaded. Could not load module /.udlibs82/libunidata.so. System error: Permission deniedHas anyone encountered this error?

We have noticed that when a session has a record lock, cleanupd won't clean it up right away.  Is there any documentation about the rules of cleanupd, as to how the times can be configured - or even IF the times can be configured - and how long it waits for a record lock to be released before it reaps the disconnected session?

hi everybody,a question for experience sharing.on a very secure Windows server environment, how to define a non-administrator user to give him the rights to execute 'elevated' commands like MASTER, UNLOCK, ... etc.any ideas?thanks by advancemanu

Rocket,I looked the other day to checkout the free evaluation copy of UniVerse. It has an expiration date of 6/2022! UniData is sometime in 2023. Is the expiration date on UniVerse incorrect? Jon

Please advise With the ongoing power failures, we are experiencing that users are beingkicked off from their pc's or terminals , But the user session is still openon the server. In other words, when doing a LISTU it still shows theseusers as being logged on. Is there a config/timeout-setting that can logoffthese dead sessions automatically after e.g. 1 minute? RegardsLappies Labuschagne -- This email has been checked for viruses by Avast antivirus software.https://www.avast.com/antivirus

We are writing a deployment process for Azure and need to be able to set a Bash error if the deployment process generates an error. The script is executed from the shell level with "uv DEPLOYSCRIPT' and it will exit back to the shell when done. So far, after each test, I'm seeing a Bash exit code 0... How do I force an exit error, better yet with a message such as 'exit 1 FAILED TO COMPILE ABCD EFGH'...------------------------------Jeff TeterWoodforest National BankThe Woodlands, TX------------------------------