Rocket® U2 | UniVerse & UniData®

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

I am writing a paragraph to script compiling programs and am creating a log record using the DIVERT.OUT capability. So, the DIVERT.OUT command is set up to be:DIVERT.OUT ON log_file THIS.PARA APPENDI want to add the date to the name 'THIS.PARA' so that the command would be:DIVERT.OUT ON log.file THIS.PARA.<<P,THIS.DATE>> APPENDSo, I am trying to set 'THIS.DATE' to a date in the form of 'yymdd'.i have a program that will set paragraph variables but at this point, that program is not yet compiled and available. Suggestions for a simple way to do this just in the paragraph?Thanks!

Hi, I'm Zhuo Liu (Joanna), Rocket Automation Team Scrum Master, and I'm going to showcase the details of our DevOps efforts to ensure consistent quality in our data server products including: Continuous integration smoke tests and regression tests Conversion of manual test cases to automated tests Automation enhancements such as bringing flexibility to existing auto cases and Smart Installer Whether you’re interested in our efforts to release quality products or if your organization is looking to make the switch to Agile product development, there’s plenty of great information in this MVU virtual event.   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 #DevOps #UniVerse #UniData #Performance ​​​​​ ------------------------------Joanna LiuEngineer in TestRocket SoftwareDalian+8641139404648------------------------------

Hi, my name is Chris Rizza and I am the Product Manager for the Rocket MV Databases. UniVerse 11.3.2 was launched in early 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, @Neil Morris, highlight and demo the following features:  New Features Sequential File I/O replication UTC Date Time Geospatial support  Security OpenSSL 1.1.1 features Self-Signed/Default Root Certificates demo  Python Python v3.7 Windows, Linux, AIX, Solaris Python performance improvements  External Database Access Support for MySQL and PostgreSQL Datetime field support EDA file size reduction  Supportability Linux 8 certification #MVU #UniVerse #NewRelease #Upgrade #Security #Performance ​​​​​​​​​​------------------------------Christine RizzaMV Product ManagerRocket Software------------------------

I need someone to help me through setting up EDA replication on a UV/Windows server connecting to SQL Server.  The documentation doesn't seem to make sense and I can't figure out how to make it work.------------------------------Kevin KingPresidentPrecision Solutions, Inc.------------------------------

Hi all.Hope someone could share some light on this for me.I'm calling an API in Python using Basic to fire the call ( WooCommerce ) I then receive a JSON Response in the below format [ { "id": 799, "name": "Ship Your Idea", "slug": "ship-your-idea-22", "permalink": "https://example.com/product/ship-your-idea-22/", "date_created": "2017-03-23T17:03:12", "date_created_gmt": "2017-03-23T20:03:12", "date_modified": "2017-03-23T17:03:12", "date_modified_gmt": "2017-03-23T20:03:12", "type": "variable", "status": "publish", "featured": false, "catalog_visibility": "visible", "description": "<p>Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi vitae est. Mauris placerat eleifend leo.</p> ", "short_description": "<p>Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac

We have converted a number of our files from 32-bit to 64-bit over that last couple of years. Typically, that has been done when we have a write issue and react to the specific problem. Does anyone have a dictionary or programmatic means of identifying the two type of file so that we can target conversion proactively?Once the files are identified, they can certainly be resized to 64-bit via a script.------------------------------Jeff TeterWoodforest National Bank------------------------------