Rocket MultiValue

Running UD 8.3 on AIX with plenty of disk space. I have a number of large files (10M-50M) records that I want to re-size to improve overall performance, but more importantly, prevent any file corruption due to any file re-sizing activities. I am trying to find out what is the optimal number of records that each group should contain: 1- Is there a recommend number of records per group (keep it under 20 or a certain number)? This will allow me to properly size block and modulo.  2- Should I keep increasing size of the block until I have zero level 1 overflow, which means ignore number of records per group? Albeit I managed modulo size in conjunction with block size. Any insights or recommendations is greatly appreciated. Thank you

After performing an upgrade from UniVerse 12.1 to 12.2.1 - we receive the message "Your VOC is out of date. Update to current release (Y/N)?" on the initial LOGTO on each account. Is there a way to just complete these VOC updates en-masse for all accounts?  Your VOC is out of date. Update to current release (Y/N)?Y Your VOC is configured for PICK compatibility Updating your "VOC" file.  (Each "*" = 10 records) *********************************************************** **** 6 item(s) were removed from your VOC file and placed in file "&TEMP&" to prevent them from being overwritten.   Updating your "D_VOC" file.  (Each "*" = 10 records) * 11 item(s) were removed from your VOC file and placed in file "DICT &TEMP&" to prevent them from being overwritten.

Anyone else getting spurious lint on the $copyright compiler directive? ------------------------------Stuart BoydellAU------------------------------

I have a complex I-Descriptor that should never output more than 2 characters.  Therefor, I have it set to "2L". Due to some bad data, a few records have 5-6 characters for this value. How can I direct the dictionary item to only out 2 chars?------------------------------Nelson SchrothpresidentC3CompleteShop LLCHarrison OH US------------------------------

I have a UniVerse file with a great diversity of record structures. Consequently I want to return the data for a record through EVAL rather than a DICT I-descriptor entry because DICT entries lead to overflows from other incompatibly structured records. FWIW, the output will ultimately be through ODBC using dynamically normalized Native UniVerseSQL. Don't worry if this isn't your thing, you may still be able to help with the EVAL I-descriptor expression I need. The values on the record in question are listed as an arbitrary number of individual attributes, which I can return as a single set of multivalues using LOWER(@RECORD) suitable to be read by ODBC. However I need to return them with the corresponding original attribute numbers and have not been able to come up with anything. Any suggestions would be most appreciated.------------------------------Greg ClitheroeRocket Forum Shared Account------------------------------

i want to install pipi package manager for python in unidata. There is someone that could give some advice?------------------------------Luis SanchezIT Application SpecialistALAMO AUTO SUPPLY------------------------------

Hi all I'm trying to run some Python programs that requiere some third party libraries and I'm having some problems installing them as a regular user. This is the folder structure: [root@~]# ls -lh /usr/uv/python/ drwxr-xr-x 2 root root 4,0K jul 17 13:21 bin drwxr-xr-x 3 root root 22 jun 15 2021 include drwxr-xr-x 4 root root 106 jun 15 2021 lib drwxr-xr-x 3 root root 16 jun 15 2021 share drwxr-xr-x 2 root root 29 jun 15 2021 syslib [root@~]# ls -lh /usr/uv/python/lib/python3.9/ | grep site-pac drwxr-xr-x 18 root root 4,0K jul 17 13:21 site-packages On another server there are some differences, and the owner is the uvdb user, not root. [root@~]# ls -lh /usr/uv/python/ drwxr-xr-x 2 uvdb root 4.0K May 16 13:14 bin drwxr-xr-x 3 uvdb root 24 Oct 18 2023 include drwxr-xr-x 4 uvdb root 114 Oct 18 2023 lib drwxr-xr-x 3 uvdb root 17 Oct 18 2023 share drwxr-xr-x 2 uvdb root 68 Oct 23 2023 syslib When I try to install some package it's going to be installed in the

We're trying to upgrade from RHEL 7 to 8 (and upgrading UniVerse to the supported versions from 12.1 to 12.2.1) Upgrading our test system to RHEL 8 (using the LEAPP in-place upgrade method) and then updating UniVerse to 12.2.1 worked as expected, and critically printing continued to work as normal. However performing this on our production system, results in printing not functioning after the RHEL upgrade. I posted about this issue when we attempted this initially last year and as suggested we've taken a clone of the production system so we can experiment with it freely. So far we've tried: RHEL Upgrade only > printing fails > then Universe update > printing still fails Universe update > printing ok > then RHEL > printing fails Printing direct from the OS level e.g. # cat testfile.txt | lpr -P PRINTERNAME - this results in printer output. So it seems performing the upgrade to RHEL 8 changes "something" in UniVerse which prevents UniVerse from spooling to the printer i

I recently discovered that d3vme /fileload on D3 Windows does NOT build indexes in the FSI accounts. VME accounts only. This was discovered when working with someone who was using d3vme /fileload on D3 Linux 10.4, since entering d3 from a Linux prompt then taking the F option is no longer the way to restore the system. The problem was further masked by the fact that list-index DOES show all of the index references even though the indexes never got built. This is because the index references in a file's D-pointer (file-defining item) get restored when the file is restored, but no further action is taken. The way around this is to run indexer from TCL in the DM account after the file-load is complete. Indexer reads all of the index references in the D-pointers and builds the indexes accordingly. As of now, we are treating this as a documentation issue since this has always behaved this way and the work-around is quite simple. I would appreciate any comments from anyone who uses d3vme /fi

Hi I'm trying to port some code so that all the uopy connections will use u2py instead, so I don't have to spend another extra license when calling my Python code from BASIC. I've been looking to the u2py code for the u2py File object and I can't see a "close" method. What's the proper way to close a file when using u2py?------------------------------Héctor CortigueraQuiter Servicios Informaticos SL------------------------------

I want to conect to unidata using unix and move with unix commands in the terminal. Im new to unidata any advise to get connected?------------------------------Luis SanchezIT Application SpecialistALAMO AUTO SUPPLY------------------------------

When attempting to use uopy 1.4.0 with Python 3.12 on Mac OS X Sequoia 15.4.1  (Apple Silicon) I get the following exception when trying to connect to a Universe server:   File "*redacted*/.venv/lib/python3.12/site-packages/uopy/_unirpc.py", line 159, in __init__    self._socket.setsockopt(socket.IPPROTO_TCP, socket.TCP_KEEPIDLE, 1)                                                ^^^^^^^^^^^^^^^^^^^AttributeError: module 'socket' has no attribute 'TCP_KEEPIDLE'. Did you mean: 'TCP_KEEPALIVE'? The above exception was the direct cause of the following exception: Traceback (most recent call last):    session.connect()  File "*redacted*/.venv/lib/python3.12/site-packages/uopy/_session.py", line 268, in connect    self._rpc_connection.connect()  File "*redacted*/.venv/lib/python3.12/site-packages/uopy/_unirpc.py", line 105,

I have some questions / confusion concerning shells. I know that at different companies I have worked they have allowed different shells - korn, bash, bourne, etc.  Is there a standard for invoking each of these shells or is that defined by the admin within each system? !sh, !ksh, !bsh.  Is there any documentation on how to set these up? A way to know which shells are being invoked by the commands?  And a way to update paramaters within each? Thank you for your time, Kathleen------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------

Have you thought about changing the CENTURY.PIVOT? We've had some customers attempting to report date bugs as we approach 2030 which are in fact not a bug at all but just a misunderstanding of the CENTURY.PIVOT setting. The century pivot point is the year used to determine the century when an ICONV is done on an external date that only provides a 2-digit year. I have attached a results spreadsheet to this post, so that you can review the different results of setting CENTURY.PIVOT against a 2-digit year ICONV and then seeing the result using an OCONV with a 4-digit year. You can check the century pivot point with the CENTURY.PIVOT command at ECL.>CENTURY.PIVOTCentury pivot date is 1930 You can change the century pivot point for your current session with the CENTURY.PIVOT command, or change it for everyone by changing it in system wide configuration file. (udtconfig for UniData and uvconfig for UniVerse ) From the UniData Help The CENTURY.PIVOT ECL command overrides the system-wide ce

Good Day Fellow Members! I have an interesting issue with the "LOGTO" SB+ command.   I am trying to allow a specific Security Group to have access to our TRN.DATA account.  (Our "TRN.DATA" is a our "sandbox" account to allow our power user(s) to test new processes and/or experimenting with setting up our business needs.) Currently, when I ask the user to perform a "/LOGTO TRN.DATA" , they get "TRN.DATA ACCESS DENIED".   (I have added an attachment on what the users are seeing.)    I have tried to add the account to the Security Group through the SB+ Security Group Maintenance, but the updated data is not being saved to the Security Group record. I did ask our Unix administrator to check the permissions and our admin did make adjustment to all user to access the account.  However, this did not resolve the issue. So, my question to the group is what I am missing?  What do I need to look at or investigate? Any suggestions and feedback will be welcomed. Thank you for your time and consider

Big news for MVIS users! The latest release, MVIS 2.2.0, is packed with customer-driven enhancements designed to make the system more flexible, secure, and high-performing. One of the standout updates is the Flexible Deployment Model, allowing customers to choose between local storage and MV storage for metadata-giving them the power to tailor their infrastructure to their needs. Security gets a major boost with Enhanced Audit Logs, making system activity tracking more detailed and robust. Performance monitoring is now sharper than ever, thanks to Temporality Support for Open Telemetry Metrics, ensuring a clearer view of how systems behave over time. The update also introduces Improved Open Telemetry Functionality, letting users control the export of traces and metrics to reduce unnecessary traffic. For logging and troubleshooting, MVIS 2.2.0 brings a JSON Log Emission Option for seamless integration with modern monitoring tools, Improved Error Codes for more precise issue resolution,

Greetings!I'm not sure if I can explain this one very well, but I am going to try. We are running UniVerse 11.3.5 on AIX 7.2.  We noticed some oddities when writing to a Type 19 file.At the AIX level, the ownership of the Type 19 file (parent directory) is root, and the group ownership is a group called installs.  UV runs as root. User xyz (group staff) runs a process that writes to the Type 19 file.  If I monitor the contents of the folder at the Unix level with an "ls -l" command, and my timing is perfect, I will see that the UV record (Unix file) first gets created as a 0-byte file with xyz as the owner and staff as the group.  UV then finishes writing the file and at that time the owner is now root with a group of installs.This all happens in milliseconds, so trying to capture it 'at will' is nearly impossible.  I just keep running ls command repeatedly until I see it. I've never noticed this before, but I've never looked before either.  I'm looking now because we have another pro

Hello all - I'm sure this has been asked before but I couldn't find exactly what I was looking for... We are moving our Unidata 8.2 from Unix to Linux. I have been through such a conversion before some 15 years ago but thought others might have more recent recollection and encountered other issues. Is there a list of specific potential pitfalls to check?  Obviously the syntax of Unix commands changes to linux. Spoolers, FTP, emails, etc but what about any Unidata changes? I remember issues with the locate command... did others have that issue also? What other issues did you all find? Thank you in advance for your time, consideration, and assistance. Kathleen------------------------------kathleen hambrickProgrammerRocket Forum Shared Account------------------------------

Would anyone know the setting to prevent the indent on labels as seen here? (if possible).  Thank you ------------------------------David KylesDirector of ITMDC Interior SolutionsGlendale Heights IL US------------------------------

I have just loaded python3.13 and flask onto my rocky 9.5 system.  The system already has python3.9 as part of the rocky linux.  I have just installed idle3 wanting to use it to work with python3.13 and flask but find that it connects only to 3.9 where I do not have flask.  Does anyone know a way to either modify idle to connect to my 3.13 version or is there any way to get the "dnf install" to load it into my 3.13 directory structure?  I prefer to use idle instead of the plain 'ol text editor. Thanks, Dale

I keep getting the following error when migrating my UniData application to SB 6.5.7 In /usr/ud/SB.DEFN/DM/_SB.DISP at line 173 can not access unopened file. File variable not used in file operation In /usr/ud/SB.DEFN/DM/_SB.DISP at line 173 Fatal error: WRITE error How do I deal with it? The file is there with the correct permissions but I am not sure what it is referencing at line 173 so I cannot update the respective VOC pointer------------------------------John FigloreRocket Forum Shared Account------------------------------

Hi, I'm new on Unidata. Right now our company is using Manage 2000 with Unidata RDBMS 8.2 version. My question is, is it possible to open my unidata database to SQL Server Management Studio, how? If it's not possible can I create a view on SQL Server Management Studio containing all the data from my unidata database, how? I already created a view file and successfully compiled it but I can't still see it on the SQL Server Management Studio. I also created a link server on SQL Server Management Studio using the U2 ODBC.

Greetings Fellow Members! My co-worker and I have a issue with SB+ that we are banging our heads because we cannot find a solution. Below is a snapshot of the problem   As you can see,  our "PTEXT" is not getting opened, here.  However,  this is happening with other files, like our "HELP" and "DEFN" files.     Almost all of are users are using GUI, but this has popped up with one or two users who use the Character mode.  To make this more interesting, the following could happen:  This doesn't happen all the time.  When the user clicks on the "Continue" button (Sometimes they have to hit the "Continue" button multiple times), the error message eventually goes away.      Lock up their session and need to kick the user out. I have checked the VOC pointers and they are correctly pointing to the correct data files and dictionaries.  We believe it is coming from our SB+ interface and/or other processes.  &nb

I just bought a copy of OpenQM to test some of my applications.  My first program to test is a main menu.  In this MVBASIC program I draw a character outline around the border of the screen, the fill in the menu options.  The program then calls a suproutine called XPRMT.  I use the XPRMT subroutine for all keyboard input in all programs, it is the only INPUT statement in my systems.  One of the parameters that I pass to XPRMT is PSTR which is the prompt string which XPRMT prints at @(0,24), the bottom of the screen.  In UniVerse this routine works perfectly, but in OpenQM it was displaying the PSTR value over the bottom line of the border which is row 23.  My last line printed in the menu program was the log off selection at row 22.  After much code changing in XPRMT, I modified the menu program to display the menu selections first and the draw the border and that presented everything properly.  What I see is that even though the XPRMT instruction is "PRINT@(0,24):PSTR;", PSTR is being

we have had a recent issue with QMRESTORE creating files with casing on. Once the restore is done, we are having trouble with cases of dictionary items, etc (coming from D3 environment). I delete the file then I do      create.file FRT.CHG NO.CASE copy the data and dictionaries from a temp file back into my newly created file, and all works as I would expect. Can I change a fie to be case insensitive without re-creating it. My master login in the QMSYS account has OPTION CREATE.FILE.NO.CASE This is QM ver 4.0.9------------------------------Jesse TilliaProman-ERP, Inc.West Seneca NY US------------------------------