Rocket® U2 | UniVerse & UniData®

I am running AIX and ksh.  At the AIX prompt, I have: AIX $ which matches the value for PS1    PS1='AIX $ ' when I issue the SH command from Universe,  I get to the host system.  I can issue AIX commands (without issue I think)However,  the Prompt is NOT displayed.  It is just blank The shells are linked together: $ ls -al | grep 326868 # -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  ksh# -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  psh# -r-xr-xr-x    5 bin      bin          326868 Sep 12 2023  rksh# -r-xr-xr-x    5 bin      bin &n

Hi, We recently encountered a data file corruption on key files. This was causing our app to fail. Does anyone in the forum have knowledge of any tools that will send email alerts once a new entry is logged into the \\U2\\unidata\\bin\\udt.errlog. Thanks in advance for recommendations. ------------------------------[Darren] [Johnson] [Australia][Snr Dev Engineer]------------------------------

Using a BASIC program, I need to read filenames and file dates from an AIX directory and compare them with names and dates held in UniVerse records. If the files are present among the UniVerse records then they need to be moved out of the directory and more files added from another directory. Any advice or code snippets much appreciated.

Could someone explain why these messages appear and the shell window closes when I use Ctrl-C and then option D while running a Unibasic program? ------------------------------Mark MartinNARocket Forum Shared Account------------------------------

We upgraded our development server to Universe 11.3.4 and one of my programmers wants to work with Basic Profiling, in particular the bpf program. Where do we find it? I had understood that it was available on this version, but it's not in $UVHOME\\bin.------------------------------Phillip PotterV.P. R&DData Management Associates Inc DMACincinnati OH US------------------------------

We use @USER0 for an application-level constant.  We set it in the LOGIN paragraph & it should remain constant. I've seen it sometimes - but not always  - get set to 0 after/while? I've used/exited(?)/re-entered(?) RAID.  I haven't pinned down what triggers  it. Ironically, the reassuring thing is that RAID is disgustingly buggy.  I've had problems in RAID that don't happen when real users run things for real.  So it's probably ok in production.  Probably. Anyone else seen something like this?------------------------------Chuck StevensonDBA / SW DeveloperPomeroyUS------------------------------

The Rocket MV team is pleased to announce the release of Rocket UniData 8.3.2 and Rocket MultiValue Performance Experience (MVX: Performance) 1.10 on April 25th, 2024. UniData 8.3.2 is the first UniData release certified with the Rocket MultiValue Performance Experience (MVX: Performance) 1.10, which is available for our customers on maintenance. MVX: Performance monitors the performance of your UniData server and provides DBAs or developers with a better way to track down issues. It determines the root cause of issues, including the server, the operating system, the hardware, or a combination. DBAs can easily receive alerts when over 40 performance monitoring events occur, so constant monitoring is not required.  In addition, UniData 8.3.2 and MVX: Performance 1.10 provide you with an enhanced replication experience, bolstering High Availability and Disaster Recovery (HA/DR) capabilities. UniData 8.3.2

For a conversion project at a customer with 4000 custom programs written over 30 years we're trying to get a handle on which programs are actively used.  One idea that's been floated is running a monitoring program as root from the demo account that does the pseudo code below. By definition we'll be running this in production for a month or three, and there's some justified nervousness about any potential performance impacts.  I don't think the monitoring program will be a performance hog itself, but not sure if doing PORT.STATUS on the probed program has any effect - does it "pause" the probed program so the stack collected is consistent for example?  We're not expecting to get 100% coverage from this, but even 80% would be a huge help. Anyone ever done something like this for real?  Any war stories or hard-won words of wisdom to share?  Thanks for reading! LOOP EXECUTE 'LISTUSER' LOOP FOR EACH ROW IN LIS

Hello, Our apps are written in SB+ which use a cached opened files, in named common block SBPLUS & SBFILES, of 30 + 750 = 780 filevars (result of OPEN file TO filevar from BASIC). Some of our app's files are indexed, dynamic or distributed.  It means, with 780 cached filevars, we open more than 1000 os file.  With release 11.x we are used to set MFILES 3000 without never a trouble.  Now r12, r14 introduce SESSION_NFILES limit. Which is session's ActiveFileTable instance. SESSION_NFILES is not defined in uvconfig. CONFIG ALL report SESSION_NFILES = 800 ; aka. MFILES x 4) Then, at basic runtime we encounter OPEN file to fv ELSE CRT STATUS() =  -25 which is Exceeded SESSION_NFILES file table resource.  I try to push MFILES from 200 to 300 or set

I would like to obtain the workstation hostname when a user logs into a Linux system.  I had it available on our Solaris Unix server but not on our RHEL8 server.  We use this to identify a physical location and to associate network printers nearby.  I am able to get the workstation hostname when in Citrix and by using Accuterm and checking a Session clientname but it is not always present when directly on the network and wondered if it was somewhere else Available to Accuterm.  Where can I found out the PC workstation hostname and what other windows information like this might be available to harvest? 0097:             * Check for citrix environmental variable CLIENTNAME0098:             SCRIPT = 'InitSession.Output Environ("CLIENTNAME") & vbCR'0099:             CRT CHAR(27):CHAR(2):'P':SCRIPT:CHAR(13): ; INPUT CLIENTNAME: ;  IF CLIENTNAME # '' TH

hello,  Under UV r14, these 2 uvconfig GLM_MEM_ALLOC / N_GLM_SELF_BUCKET are documented as :  GLM_MEM_ALLOC - The number of lock nodes allocated for each memory request. This parameter is highly application dependent. if the application requires a large number of locks in one transaction, this setting should be increased to the maximum number of locks per transaction * 2.  N_GLM_SELF_BUCKET - The number of hash buckets for the per-process locking table. This parameter is highly application dependent, If the application requires a large number of locks in one transaction (more than 20), you should increase this setting to the closest prime number to the maximum number of locks per transaction.  So, they are delivered 

I am indexing a 21,000,000 record file on the invoice date.  It is a single value field, and when I build the index it works correctly based on the records in the file at the time of the build.  After that, new records or changed records are NOT added to the index. Is there a setting related to indexing that must be set to auto update the index? I have read all the UniData documentation on indexing that I can find. I have been using indexes in other versions of Pick for decades and this is the first time I have hit this problem.------------------------------Bob LislePresidentInformation Technology SystemsDallas TX US------------------------------

I noticed that when I executed two select statements in a basic program, the 2nd one does NOT utilize the results from the first one: CMD1='SELECT FILE WITH ATTR1 EQ "Y"'' EXECUTE CMD1 CMD2-'SORT FILE F1 F2 F3 F4' EXECUTE CMD2 But, if I combine them it works: MULTI.CMD=CMD1:@AM:CMD2 EXECUTE MULTI.CMD Problem: is there a way to keep the 2nd command from running if the CMD1 finds 0 records? ------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

hello, So, Universe >= r12 use the same lock system like Udt, I'm looking to deeply understand/tune it. For admin & troubleshooting, there is a tool uvglm_tool / glm_tool  and uvulc_tool / ulc_tool, but they are not documented or I do not found any docs about it nor in Unidata docs.    Is there anyone who have details about it ? How to read the info, use it ? Perhaps docs/pdf/ppt/whitepaper/KB/...  from U2University conferences in the past ?  I thank you by advance. ------------------------------Manu Fernandes------------------------------

Are there any examples written in Flask or other tool that uses REST tocommunicate with Universe using MVIS to do data entry? A customerdemographics app for example. What is a good design pattern to support thesession and record locking?Thanks

Our ERP system utilizes UniVerse and I'd like to train some our support team members to become UniVerse Administrators. Is there a Rocket program or Contact I can reach out to for assistance?  ------------------------------Matthew WestDirector of Software DevelopmentIntegrated Supply Network IncLakeland FL US------------------------------

We have a file that is used to find customers via a name & address formatted "matchcode".  This matchcode file has an index for customer number, as it has 38M entries.  For example: MATCHCODE:     4537100110WSTLM00000BSHT0001 599386130002 58926904 Often, there are more than one customer number (attributed) associated with a matchcode as shown in this example.  It seems that only <1> is indexed and not the others (.  Is this a function of how UniVerse indexes, or the dictionary value used or is it a function of how the index was created? >LIST-INDEX MATCHCODE ALL Alternate Key Index Summary for file MATCHCODE File........... MATCHCODE

We are upgrading from RHEL 7 to 8 to 9.  Then, we will need to upgrade UV 11.3.1 to 11.4.1. We are considering only going to RHEL 8, but UV 11.4.1 is certified for RHEL 9. Is anyone running UV 11.x on RHEL 9?  Any issues with it? 

hi everybody. A strange behavior we do not understand. on a UV/windows / 11.3.5 we have python 3.11  (the one within uv/python - no other python is installed on the machine)  We  use module 'pandas'  in our script, release 2.2.2 is installed.  When executed from osshell, no problem : dos /c "python path/script.py"  When executed from uv/python, from pyCallFunction() or from TCL >PYTHON then import pandas we get this  DLL load failed while importing aggregations: The specified module could not be found.we do not understand what's wrong with the deploy.... What is the

Any one using the Windows ReFS file system for either UniData or UniVerse? What's your experience performance wise?------------------------------Christian BristowTSERocket Software IncWaltham MA US------------------------------

Hi Guys,I've got a weird issue affecting a couple of my users.The users all use SB Client V6.3.1 and login to the GUI interface, where they have access to SB + menus and have the facility to create their own User Menu, they typically put their "FAVORITES" that appears as a "window" on the left hand side of their main screen, which should look similar to this, dependant on what the user has added to the menuHowever this is what the users are seeingas you can see from the above the TEXT for the menu does not display correctly, at the point of logging on the text and menu structure is momentarily displayed.A full removal and re-install of SB Client doe not resolve the problem, no

Rocket MultiValue Integration Server (MVIS) 2.1.0, available today, is a major release with significant new features and enhancements. To learn more about MVIS 2.1, please plan to join us on September 4th, for a product launch webinar. MVIS 2.1 Features and Highlights Power Modernization via the OpenAPI Standard OpenAPI 3.0 Support. OpenAPI 3.0 is the first major release since 2015, when Swagger was adopted as an open standard and transitioned to the OpenAPI Initiative. The 3.0 spec includes numerous changes including a simplified structure for increased reusability. You can find additional details in this blog post

Hi Rocket,  Can you tell us more about uv r14 ?  Regards------------------------------Manu Fernandes------------------------------

We're currently on UniVerse 12.1.1 and RHEL 7. As RHEL 7 is EOL - we'll need to upgrade to 8, and then update UniVerse to 12.2.1.2002 The team who will conduct the OS upgrade have asked if UniVerse will support a Leapp upgrade, and if UniVerse will support RHEL 8.6 specifically. Has anyone else been through this process? I only see mention of the major versions of RHEL in the support matrix, I'm assuming that it will work on 8.6 but it'd be great to get some confirmation!------------------------------Matthew WrightAnalystTomago Aluminium Co PTY Ltd.Tomago NSW AU------------------------------

It has become unacceptable to expect or enforce the need for a manual authorization at the end of installation or upgrade. With the  latest release of UniVerse we have also published a tech note article that covers a  Python script to Automatically License / Authorise / Authorize UniVerse and UniData. Search our knowledge for 'How-to-Automatically-Licence-Authorise-UniVerse-and-UniData' or article number '000054994'. Any updates I make to the script between releases will be done via the technote. I hope you find it useful. ------------------------------Jonathan Smith UniData ATSRocket Support------------------------------