Rocket® U2 | UniVerse & UniData®

So you might have read my other posts regarding Dynamic (Type-30) files in UniVerse. Until recently I have not had much to do with dynamic files. Now that I am looking at them in detail I am looking for resources that will help me get a handle on how to size them correctly and build them to suite the intended data load. Are there any in-depth resources on Dynamic files available? Thanks Gregor Scott ------------------------------Gregor ScottSoftware ArchitectPentana Solutions Pty LtdMount Waverley VIC AU------------------------------

Has anyone come across this error message before?  Is the number of files that can be open listed somewhere?  The application uses an openfile routine to keep track of the most recently opened file and assigns the file variable of the open file instead of opening it again.  The array in it may be too large and need to be reduced. Program "!SET.PTR": pc = A96, Unable to create capture file.[EMFILE] Too many open files

Further to the fun I had trying to get the SEQ.NUM option to work on a dynamic file creation in a Pick account, I am now having extra fun with dynamic files. I'm kind of thinking the manuals on this subject are not at all helpful - there are lots of plain syntax explanations but none of the nuanced guidance needed to actually master this stuff. My current challenge is to create a Dynamic file with specific Dictionary specifications (the default of 'Type 3, Modulo 1, Separation 2' are not appropriate) and with non-default dynamic file settings. Given the issues with Pick-style CREATE.FILE and dynamic files I thought I would simply create the DICT file first, then create the data file. This is how that turned out: >CREATE.FILE DICT TESTFILE1 53,2,18Creating file "D_TESTFILE1" as Type 18, Modulo 53, Separation 2.Added "@ID", the default record for RetrieVe, to "D_TESTFILE1".>ICREATE.FILE DATA TESTFILE1 30 GENERAL GROUP.SIZE 6 MINIMUM.MODULUS 2456"TESTFILE1" already has a DATA defini

What do GA, EOM, EOS, and EOLS mean?

Is ANALYZE.FILE meant to give different averages for the same items in different spec'd Dynamic Files? I had an expectation that record size averages would not change regardless of the setup of the dynamic file. I was wrong, aparently. This is my initial test file >ANALYZE.FILE TEST_DYN STATS NO.PAGEFile name                               = TEST_DYNFile has 301 groups (each * represents 10 groups analyzed).******************************File name ..................   TEST_DYNPathname ...................   TEST_DYNFile type ..................   DYNAMICFile style and revision ....   64BIT Revision 12NLS Character Set Mapping ..   NONEHashing Algorithm ..........   GENERALNo. of groups (modulus) ....   301 current ( minimum 1, 0 empty,                                            300 overflowed, 300 badly )Number of records ..........   2455Large record size ..........   1619 bytesNumber of large records ....   1951Group size .................   2048 bytesLoad factors ...............   8

Seems to me they do the exact same thing.  What's the difference?

Hi all We're getting an unexpected error code when users try to log in into Universe and the maximum number of users is reached. Instead of getting the usual 39134 error code we receive 1449750101. It's a weird number, so we did some further investigation Turned into hexadecimal we get 0x56696E55 All the numbers fall into a rather small range, within the letters in the ASCII table. So, turning it into ASCII characters we get "VinU". Accounting for endianess, this is "UniV". We are getting a messed up error code from a (we suspect) dangling pointer that it's pointing to a string area instead of a proper integer. This is under Windows servers, running 11.3.5 UniVerse. ------------------------------Héctor CortigueraQuiter Servicios Informaticos SL------------------------------

I recently installed the Unidata personal edition, 8.2.4 (Windows installation).  I am now trying to connect to the server (localhost) with the "Administrator" account.  However, it tells me the Administrator account has expired. Is there is a different administrator account that I should be using?  Thanks in advance for your help.

I am attempting to test a new routine that retrieves file specifications in BASIC (using a combination of the STATUS xx FROM fv statement and the FILEINFO() function). Naturally I have tested against variations of the hashed file types (types 2-18). It attempting to test dynamic files I have found that I cannot create a type-30 file that uses the SEQ.NUM algorithm. >.L RELLEVEL      RELLEVEL0001 X0002 11.3.50003 PICK0004 PICK.FORMAT0005 11.3.5>>CREATE.FILE TEST.DYNAMIC_4 3 DYNAMIC SEQ.NUMCreating file "TEST.DYNAMIC_4" as Type 30.Creating file "D_TEST.DYNAMIC_4" as Type 18, Modulo 3, Separation 1.Added "@ID", the default record for RetrieVe, to "D_TEST.DYNAMIC_4".>ANALYZE.FILE TEST.DYNAMIC_4File name ..................   TEST.DYNAMIC_4Pathname ...................   TEST.DYNAMIC_4File type ..................   DYNAMICFile style and revision ....   64BIT Revision 12NLS Character Set Mapping ..   NONEHashing Algorithm ..........   GENERALNo. of groups (modulus) ....   1 curren

Hello,  I am migrating our production application (Prelude) from a UNIX to Linux environment. Currently, I am working on moving the U2 ODBC database. UniData is installed and working on the system and presents correctly in Prelude, however the ODBC database is having some issues. When I attempt to connect using U2 ODBC drivers, I can only interact with 5 out of the 40 tables present. The account used to manage these tables/subtables/views has owner permissions on the db and is part of the same groups as it was on Unix. I am not sure where to continue my troubleshooting efforts here, but direction/suggestions are greatly appreciated.------------------------------Phaelen Stuart-BergIT Systems ManagerRocket Forum Shared Account------------------------------

We're pleased to announce the availability of UniObjects for Python (UOPY) v1.3.0 on October 12, 2023. UniObjects for Python offers many benefits including:•    Provides remote access to MV servers in Python, great for your developers who don't know BASIC•    Offers full stack development in Python: from web server (UOPY) to database backend (U2py)•    Ability to leverage the Python ecosystem including many 3rd party libraries•    Enables rapid application development•    Delivers an open and extensible UniObjects client•    Helps attract new development talent UOPY v 1.3.0 enhancements and bug fixes: Enhancements•    We've added a new uoserver_timeout attribute to uopy.Session, which allows the UO server to retrieve the timeout value from the unirpcservice file. This feature requires UniVerse 11.3.5, UniData 8.3.1 or later versions.•    The fileInfoEx method of the uopy.File object now provides more fileinfo details for the UniData server•    From within Python, you can now determine

If you are considering upgrading to Rocket® UniVerse 11.4.1 and use either Rocket SB/XA (all releases) or Rocket U2 Web DE 5.3.0 or below, you need to plan your upgrade to avoid disruption to your System Builder and Web DE applications. Rocket UniVerse 11.4.1 includes OpenSSL 3.0. With the upgrade of OpenSSL, we also disabled unsafe encryption algorithms including:•    Hashing Algorithms / Message Digests: MD2, MD4, MDC2, WHIRLPOOL, RIPEMD160•    Symmetric Ciphers: Blowfish, CAST, DES (DES_ECB, DES_CBC, DES_OFB, DES_CFB, DES_CFB1, DES_CFB8 and DESX_CBC), IDEA, RC2, RC4, SEED•    Key Derivation Function (KDF): PBKDF1 Both SB/XA and U2 Web DE 5.3.0 (and earlier) rely on disabled encryption algorithms and won’t work unless you reenable them. For SB/XA your options are:•    Enable legacy algorithms (instructions below)•    Postpone your UniVerse upgrade. We are working on a Hotfix for SB/XA 6.5.7 to upgrade the encryption algorithm used by SB/XA. We plan to release the hotfix before the en

I sometimes see an error message when trying to re-license after an update (which I've been doing a lot recently to get customers up to 3003). "This web address is for US and Canadian customers of RBC.  Please click OK and click the indicated URL to continue." This is from https://rbc.rocketsoftware.com/authprod.asp.  I usually wait a day or two (but not ten!) and go through the process again and it usually seems to work.  I could be entering the details a different way the 2nd time?  The customers work with the VAR to get the license details, so I'm one step removed from requesting and managing the serial numbers, they just call me when they need help. Anyone else seen this, or have advice on what I'm doing wrong? ------------------------------Ian McGowanPrincipal ConsultantRocket Forum Shared Account------------------------------

I saw some teasers for 8.2.5 a few months back - is there an online "what's coming soon" for Unidata anywhere?------------------------------Ian McGowanPrincipal ConsultantRocket Forum Shared Account------------------------------

I've been asked this before, but did not have an answer!  On Unidata -- in a dictionary -- to do a multivalue OCONV, the command is SUBR("-OCONVS",X,Y) The question I got asked:   "Why is there a "-" in front of that code?" And I was not sure!  Is that because it's a system function?  It's not actually documented as to WHY -- just that it IS. I just looked over the Using UnIData 8.2.4 doc to make sure it was not something documented. Anyone know for sure what the "-" infers or confers beyond my guess that is means 'this is a built in system command'?------------------------------David WolvertonIndependentSunset Programming IncWaltham MA US------------------------------

Hi all, we have many web aplications invoqued from some users via unirpc, and sometimes we are out of available licences for interactive users, are there a way in universe to limit the number of connections that each user can start? 

This is the second MVX: Performance release focused on improving replication as part of a MultiValue HA/DR strategy.  This release includes a new replication dashboard allowing users to quickly and easily perform replication monitoring tasks to assess, in real time, the health of replication activities. The replication dashboard includes details such as a statistical summary of multiple distributions and identifies the stalled LSN causing a subscription group to stop processing. A stalled LSN has been the number one replication-related support case our customers have submitted. This version of MVX: Performance provides resolution steps without users having to reinitialize servers. The dashboard also displays trend information such as pacing time behind and time to catch up.  In addition, v1.8 features three new replication events: ·        Replication disabled event: generated for one event per distribution if any groups are disabled. ·        Replication down event: generated if repl

MultiValue Experiences version 1.8.0.1347 has been released on October 19 2023 for the below platforms/versions:AIX POWER       7.1,  7.2,  7.3AlmaLinux       8CentOS       7,  8RedHat Enterprise Linux Intel       7,  8,  9Rocky Linux       8Windows       Windows 10,  Windows 11,  2016,  2019This product is available to order immediately via your Rocket software provider or by logging into your RBC account at https://rbc.rocketsoftware.com or https://rbcint.rocketsoftware.com.Additional Product Information is available on the Product Availability Matrix at https://rbc.rocketsoftware.com/matrix.asp or https://rbcint.rocketsoftware.com/matrix.aspFor any questions on product availability, please contact rbc@rocketsoftware.com.

Nevermind, figured it out. Apparently this forum is an excellent rubber duck. If some kind soul at Rocket would add SQL.WLONGVARCHAR and SQL.WVARCHAR to ODBC.H that would be very nice.

I am on Universe. I get the following message when I try to delete a file.  "unable to unlink the operationg ssytem file" then it lists the file name. Then it follows with "DELETE failure". What does this mean and what can be done about it?------------------------------Konson GeeProgrammerLiahona Development SolutionsBonney Lake, WA, United States------------------------------

it comes with openssl 1.1.1n  it is possible to update the openssl version by: replace the version in udt version sym link to another version  update the path so it find the redhat version first some other way/suggestion that I am not aware of and will this break anything in udt? thanks dougc ------------------------------Doug ChancoUniverse ProgrammerSelf Registeredgraham NC US------------------------------

Introduction I've installed the U2.EntityFrameworkCore NuGet package and successfully set up basic queries using my DbContext. Now I've hit a roadblock trying to call Universe subroutines Problem Description With basic CRUD operations functioning as expected using my DbContext, my next challenge is to call Universe subroutines. I can't seem to find clear documentation on how to achieve this when using the U2.EntityFrameworkCore package What You've Tried I've gone through the U2 Toolkit documentation, but it doesn't cover EF Core 6 specific implementations. I've also attempted to manually execute the subroutines using various EF Core methods, without any success. Questions Has anyone successfully called Universe subroutines using the U2.EntityFrameworkCore package with EF Core 6? What is the recommended approach for calling Universe subroutines in this setup? Are there any code samples or tutorials available that cover this specific scenario?

Introduction I've also installed the U2.EntityFrameworkCore NuGet package and successfully set up basic queries using my DbContext. Now I've hit a roadblock trying to call Universe subroutines. Problem Description With basic CRUD operations functioning as expected using my DbContext, my next challenge is to call Universe subroutines. I can't seem to find clear documentation on how to achieve this when using the U2.EntityFrameworkCore package. What You've Tried I've gone through the U2 Toolkit documentation, but it doesn't cover EF Core 6 specific implementations. I've also attempted to manually execute the subroutines using various EF Core methods, without any success. Questions Has anyone successfully called Universe subroutines using the U2.EntityFrameworkCore package with EF Core 6? What is the recommended approach for calling Universe subroutines in this setup? Are there any code samples or tutorials available that cover this specific scenario? #U2Toolkitfor.Net #EFCore6 #Un

I believe I was told that when upgrading UDT from a previous version maybe 8.2.x to 8.2.4 its possible to update the license programmatically? currently we have to use confprod A message displays: You have 10 days to call U2 before UniData stops working.  5.      Type Ctrl+F to generate the configuration code.  6.      Copy the generated configuration code to the clipboard; it will be used to obtain the authorization from the vendor in the next section.  Note:   Consider saving a copy of the configuration code in a text file such as Notepad.    Obtain an Authorization Code  UniData is owned by Rocket Software. No log in is required to obtain a product authorization code.  Use this link to authorize UniData: https://u2tc.rocketsoftware.com/authprod.asp  2.      Read and follow the instructions on the web page.  3.      On the Rocket Web page, change the Select Product dropdown box to UniData and click Continue.  4.      Enter your eight-digit serial number, which is the license numbe

Good day, I'm supporting a IBM Power AIX environment, which I have been working with for about a year. Along with sorting out the general maintenance of the systems and moving to AIX 7.2 there is a large UniVerse environment on the hardware I support. So I've done a little reading, as I didn't build these environments, about recommend tuning. I couldn't find anything specific, so along with what I've found, I wanted to see if there was anything else I could do or look into. We have a number of test environments, and servers that I can build to test these things on.I have found some mention of tuning JFS, first was check the type of filesystem mount, if CIO enabled disable it. Then set 'ioo -p -o j2_dynamicBufferPreallocation=64'. I've also seen mention that j2_nPagesPerWriteBehindCluster should be changed from the default 32 to zero I have some ideas of things I might like to try and see if they made a difference, setting the  "/usr/sbin/syncd 60 > /dev/null 2>&1 &" defa