Rocket® U2 | UniVerse & UniData®

My name is Qiang Lin, Principal Software Engineer.  In this session, I'm going to give you a tour of the architecture of UniVerse 12.1 with regards to the all-new Recoverable File System.  We will detail all of the lessons learned from RFS over a 20-year history and how we re-architected the UniVerse database into a two-process architecture for better data integrity, reliability and performance.  I'll show you how to configure UniVerse RFS, highlight some of the available monitoring tools, and give a demo of how to recover a database after an outage.   Note: The video playlist below can be accessed using the menu at the upper right of the frame. Click the icon to access additional videos in this series.#MVU #UniVerse #RFS ​​​------------------------------Qiang LinRocket Software------------------------------

We're excited to announce the release of Rocket® MultiValue Integration Server (MVIS) 1.3. In addition to bug fixes, MVIS 1.3 provides new features and an all new pricing/licensing model! If you haven't tried MVIS, this is the release for you. Vanity URLs: Gives you the flexibility to define and configure endpoint URLs for segmenting and managing access to your application and data to meet your business requirements. Check out the two part video by @Anand Mirasdar and @Girija Dhole to learn more. Support of oAuth: Allows your APIs to integrate with third-party authentication providers and authorization servers such as Auth0 and Okta, ensuring a good fit within your enterprise application security configuration. You can learn about security in MVIS and how to use oAuth with it plus a lot of great details in this video series by @Amey Rokde. You can find a complete list of enhancements and system requirements for Rocket MVIS 1.3 in the release notes. Watch this video introduction by @A

#UniData #Windows#PrintingFor 32-Bit versions of UniData running on a 64-Bit version of Windows (i.e., prior to UniData 8) UDT.OPTIONS 116 was added to overcome a delay of around 60 seconds when executing the SETPTR with the DEST or AT options. The effect of turning UDT.OPTIONS 116 ON changes the user ID running the command to SYSTEM, as Spooler functions run faster as a SYSTEM user. After the spooler function completes, UniData switches back to the original user ID.UDT.OPTIONS 116 should not be needed for 64-Bit versions of UniData. If you were previously running 7.2 or 7.3 versions of UniData and have upgraded to 8.2 you may have UDT.OPTIONS 116 ON to avoid the problem. Until a recent round of Windows updates leaving UDT.OPTIONS 116 ON was not problematic on a 64-Bit version of UniData other than all the print jobs that were created would be owned by SYSTEM not by the user that created them.The following two articles discuss the change that Microsoft has made in the latest security p

Recently I had to get involved in a particularly challenging problem that started happening to a process that has been rock-solid for many years.Context: UV 11.2.5 on RHEL 7We have a process that performs numerous transaction-bracketed updates.It is capable of being run as a phantom.Under the right conditions the phantom process would just stop.We have a COMO recording active while the phantom process is running, but it captured nothing of any value.The last line in the COMO was always Message[001467] For those that are interested, this is an item in the SYS.MESSAGE file >CT SYS.MESSAGE 001467      001467 0001 Spooler Entry #%i 0002 > The program that is active at the time of the abort is performing BASIC WRITE to a file whilst an TRANSACTION is active.After using strace to monitor the phantom pid I came to understand that when the phantom would die it was after updating a cacheXXXXX file in the UVTEMP directory.These are dynamic files, and are used as disk overflow of the in-mem

My name is Cheng Jiang, and I am a Rocket Software Engineer III in the Dalian office.  In this video series, we'll dive deeper into the capabilities of U2 Audit Logging to help you improve the performance and enable more fine-tuned granular control of audit logging rules.   Code Samples: UniData: https://github.com/MultiValue-University/xdemo-ud-lin/tree/master/BP https://github.com/MultiValue-University/xdemo-ud-win/tree/master/BP      TESTPROG      TESTSUB      TESTSUB1     AUD_CREATE_FILE     AUD_BASIC_WRITE     AUD_WRITE_BIG UniVerse: https://github.com/MultiValue-University/xdemo-uv-win/tree/master/BP https://github.com/MultiValue-University/xdemo-uv-lin/tree/master/BP    AUD_WRITE_BIG    AUD_DC_ENC_TEST   Note: The video playlist below can be accessed using the menu at the upper right of the frame. Click the icon to access additional

Getting the following messages when running guide:warning(development internal): file:SHS.B2B.LOG fileno:1 U_O_FFL_BITS[0] doesn't contain U_O_TMP_bits[0].warning(development internal): file:PD.BATCH.FILE fileno:0 U_O_FFL_BITS[0] doesn't contain U_O_TMP_bits[0].------------------------------Kevin KingPresidentPrecision Solutions, Inc.------------------------------

My name is Cheng Jiang, and I am a Rocket Software Engineer III in the Dalian office.  In this video series, I will give you a complete introductory tour of Rocket U2 Audit Logging. If you want to improve security or if you need help with compliance or audits, then this video content is for you.    Code Samples: UniData: https://github.com/MultiValue-University/xdemo-ud-lin/tree/master/BP https://github.com/MultiValue-University/xdemo-ud-win/tree/master/BP      TESTPROG      TESTSUB      TESTSUB1 UniVerse: https://github.com/MultiValue-University/xdemo-uv-win/tree/master/BP https://github.com/MultiValue-University/xdemo-uv-lin/tree/master/BP      AUD_BASIC_READ   Note: The video playlist below can be accessed using the menu at the upper right of the frame. Click the icon to access additional videos in this series.#MVU #UniVerse #UniData #Security #Compliance ​​​​​--------------------

Have the monitoring program use the unix 'fuser' command on each file it checks.  If the command returns a PID, then another process (the copying process) still has the file open.   We use the '-o' option, but we're running AIX so options might be a little different on Linux.   Brian Paige  

Automatic Data Encryption (ADE) is a largely-transparent database feature available in both UniData and UniVerse that helps prevent unauthorized access to selected sensitive data. This is accomplished by encrypting selected fields using an industry-standard security algorithm based upon OpenSSL and  Encryption Keys, which are held separately to the data itself. In commercial terms, this can help serve business confidentiality needs and allow a positive separation permitted levels of access and user roles. At the same time the legal compliance requirements of industry regulatory compliance such as  GDPR, HIPAA and PCI-DSS can be achieved by adopting ADE as a keystone part of a larger solutionMechanismsADE itself encrypts data at an individual field (i.e. attribute) level. If wished, different encryption and security/access criteria also can be applied to separate fields within a record. As encryption applies individually to each encrypted field, we will consider the effect of encryption

Hello Everyone,  I have installed Rocket U2/Universe Personal Edition (12.1.1/Python 3.7.3) and I'm trying to get it to work a Python virtual environment and not being successful.   Is it possible to use virtual environments with Universe Python and if so, Are there any (or can one provide) instructions for doing so? Thanks,Dave Howell------------------------------David HowellMarket America------------------------------

Could someone tell me what is the equivalent of Unidata @RM in Universe?

The XMAP and result below is from my UniVerse 11.3.1 AIX platform. They represent a simple object model containing two child tables with the same parent table. The data is from the HS.SALES sample/demo tables that come with UniVerse.Using the DB.TOXML command, also provided with UV, produces an XML file containing records from the parent table and related records from each child table. However, the fields for each record from one of the child tables are duplicated within each record node from that table. In fact, further analysis showed that the set of fields mapped for each child table will repeat count(TableMap)–1 times within each child record node in the output. This means that if there are three sibling tables defined under one parent, output for the child TableMap referenced first in the parent TABLECLASSMAP, will contain fields in triplicate; output for the child TableMap referenced second will contain fields in duplicate; and so on.This behavior was noticed during development o

Would UV/NET still work across different platforms like between a Solaris Unix and RedHat Linux platforms?  We are looking at moving to a new platform and it would be much harder without UV/NET.------------------------------Rebecca RandolphKaiser Permanente------------------------------

I stumbled across this when digging into a transaction related issue.Knowing about this might help someone in the future.Context: UV 11.2.5 on RHEL7We had a phantom process that would die unexpectedly during processing.The phantom had an active COMO recording going at the time it died, but the COMO file did not capture the error message produced by the phantom.The only way I could track why the phantom process was aborting was to have the pid launch a unix strace in background that traces the pid of the phantom, and check the trace file output at the end.The strace output file did capture the phantom's error messageThe reason appears to be that the UV phantom's COMO is only capturing the standard output (stdout). The error messages produced by the uv phantom are still sent to standard error (stderr), and this is not included in the COMO recording.#como #strace #UniVerse #rhel​​------------------------------Gregor Scottgregors------------------------------​​

UniData DBA Tips and Tricks (post #1) Getting the most out of 'guide' In addition to verification of UniData file integrity, the 'guide' command provides information about the status of the file, which can be used to plan your resizing efforts. This section, is intended to provide you with more information on using the guide statistics so you can better manage your files. In future posts, we will go over some guidelines for determining resize values, and we will go over methods to determine sizing for future growth. Note that a poorly sized UniData file impacts performance, It is recommended that you routinely check the status of your UniData files to ensure they are still properly sized. The 'guide' command's -r option allows you to put the status and statistics about the file into a UniData file for easy query access. Steps to Create and Populate the UDT_GUIDE file The UniData guide command has the ability to to store detail information about the UniData Hashfiles

When outputting to a _HOLD_ file, is there any Unidata function that will return the name of that file being created?------------------------------Kevin KingPresidentPrecision Solutions, Inc.------------------------------

U2 Replication is a very powerful, very configurable but very complex part of both UniData and UniVerse.Many customers have historically become very useful in deploying there U2 Applications into environments where the people responsible for those environments have little or no specific U2 Administration knowledge. This has been one of the many positives of deploying U2 over a long period time and we'd like that to continueTo administer and maintain U2 Replication specific U2 Administration skills and knowledge needs to be acquired. The Replication Exception Script and Monitoring Phantoms are designed to reduce this requirement, the processes and tools that we discuss here are designed to act as proactive notifications of any problems, which may have otherwise gone unnoticed and hence become a large problem later. We also look the use of an exception script when correctly designed can be used to automatically reestablish replication after some things as network interruptionsThe Replica

My name is Tim Snyder and I'm a Customer Solutions Engineer (CSE) Manager for Rocket MultiValue.  In this session, I will provide the best practices for using EDA with Rocket UniVerse and Rocket UniData application servers. EDA enables you to convert data stored in the Rocket U2 database to a 1NF database, such as Microsoft SQL Server, and then access that data using existing UniBasic programs, UniQuery, or UniData/UniVerse SQL.  If you're already using EDA or want to learn more about it, then this session is for you.   EDA CheckX Tool download: https://github.com/MultiValue-University/edacheckxd   Note: The video playlist below can be accessed using the menu at the upper right of the frame. Click the icon to access additional videos in this series.#MVU #UniVerse #UniData #EDA ​​​​------------------------------Tim SnyderRocket Software------------------------------

Do you want to: Know more about the MultiValue Experiences? Explore the NEW MultiValue Cloud roadmap? See the improvements we are making in the next release of the MultiValue Integration Server (MVIS)? Learn what's in the 1st release of MV BASIC for VS Code? I'm excited to present the 1st 2021 Rocket MultiValue quarterly livestream of the MV product roadmaps, covering Rocket® UniVerse, Rocket® UniData®, Rocket® D3®, and MultiValue tools including the MultiValue Integration Server (MVIS) and MV BASIC for VS Code. This year we've added a cloud roadmap for customers moving to the cloud. Throughout the year other MV product managers will present on both our near-future and distant-future plans, as well as the many possibilities we're still thinking about. But the only way to learn what's coming soon is to be there!Register here.Head back to the forum after this session and let us know what you're most excited or curious about.Best regards, Chris------------------------------Christine

UniData version 8.2.1.9126 has been released on 3 Feb 2021 for the below platforms/versions: Amazon Linux       2 CentOS       7 Oracle Enterprise Linux x86       7 RedHat Enterprise Linux Intel       7 SuSE Linux Enterprise Server Intel       11.0 (SP2) This 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 u2askus@rocketsoftware.com.

UniData version 8.2.2.1001 has been released on 3 Feb 2021 for the below platforms/versions: Amazon Linux       2 CentOS       7,  8 Oracle Enterprise Linux x86       7,  8 RedHat Enterprise Linux Intel       7,  8 SuSE Linux Enterprise Server Intel       11.0,  12.0 This 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 u2askus@rocketsoftware.com.

Hi, my name is Chris Rizza and I am the Product Manager for the Rocket MV Databases.  Rocket UniData 8.2.2 was launched September of 2020, but in case you missed it, here is the overview video highlighting some of the major performance, usability and security improvements we have made.  In this video, myself and Advanced Technical Support Engineer, @Jonathan Smith, highlight and demo the following features:   Performance Improvements Dynamic Array performance improvement demo Multiple Index Optimization demo Python performance improvements Security OpenSSL 1.1.1 features Self-Signed/Default Root Certificates demo Python Versioning, enhancements and platform support External Database Access New supported database additions Datetime field support Supportability Linux 8 certification BASIC improvements Replication enhancements TOJSON support demo  If you're a UniData user, then this video is definitely one you should not miss!#MVU #U

Thank you for the quick response. The reason I posted to the forums is that Rocket Support has had this issue for several months and the issue appears to have grown cold with them. This stoppage happens at least once a week so I am trying everything possible to resolve this as soon as possible.On Mon, Feb 1, 2021, 2:47 AM Jonathan Smith via Rocket Software <Mail@forum.rocketsoftware.com> wrote: Kevin, A upl_unlock error occurs when UniData cannot free a resource from it's lock table, it can be a toggle / latch, record lock, file lock or... Be sure to join the forums you're interested in to be notified of new content. Click the join button from either the forum listing page or the home page of any given sub-forum. Tip: Want a single update on all your forum memberships? Go to Profile > My Account > Forum Notifications, and check 'daily consolidated digest.' Switch the discussion email drop down to 'no email' or you will receive both.

Unidata 8.2.1 on RHEL - what does this error mean? When it happens the system usually locks up (when udt is started from the .profile) and people can't login until Unidata is forced down with stopud -f and restarted.

If you have become used to stopping PHANTOM processes by killing them or editing a controlling record in a file, there is a much more elegant method available using the often under-recognised method of process locks.For example, if we choose lock 1 to signify that a job is already running and lock 2 to instruct a job to terminate, then the code below can be used to ensure that one - and only one - instance of the PHANTOM is permitted to run at any one time:* Sample code snippet:- PHANTOM job start ** Set the PHANTOM job name *PHANTOM_JOB='WEEKLY_INVOICES_EMEA' ** Designate the locks to be used for this handshake * RUNNING_LOCK=1 ; * the lock number used by the PHANTOM when it is running * * check if the PHANTOM is running by attempting to set the process lock * that it would own if it were already running. * LOCK RUNNING_LOCK THEN * * The controlled job is not running - OK to start it * first release the lock we just set to check if it was already running. * UNLOCK RUNNING_LOCK * * now