Rocket MultiValue

Hi All, I am running D3 10.3.1.windows single user on an ASUS X555LAB Lpatop with CPU i5-5200U (2 core, hyperthreading) @ 2.20GHz (peaking 2.60GHz). running Windows 10 Home.   The program I'm running takes 4 hours to run doing full processing to find the end point. When I swap subroutines to use a file which already has the end point pre-processed and do a simple compare, it's only 20 minutes faster. It actually took twice as long with the pre-processed compare until I changed the file to be more efficient.   I have changed settings so that it's supposed to be able to use full CPU in all circumstances. (Advanced Power Options -> Processor Power Management -> Minimum or Maximum Power State = 100% for Battery & Plugged In).   Task Manager no longer allows the changing of program priorities (as you were able to in Windows 7).   My thought is that wither Windows 10 Home or the laptop is throttling D3 because when the program is running, it's using around 35% t

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------------------------------

Hi!  I'm Tim Rude, Senior Manager of Software Engineering, and I'm going to take our D3 Unix users on a deep-dive look into D3 security including data encryption, Host Authentication and OSFI tunneling for the D3/Unix platforms.  Additionally, Rocket Senior Technical Support Engineer, @Brian Cram, will show you how to setup and use of the mvWorkstation for securely connecting to D3/Unix v10.3.   In case you missed last week's post, be sure to check out Brian Cram's video series on Securing D3 Data on Windows platforms, Remote Access Security using MVSP, and SSL for MVS Toolkit.   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 #D3 #Security #Compliance​​​​ ------------------------------Tim RudeRocket 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® D3®, Rocket® UniVerse, Rocket® UniData® 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 R

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

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

Starting on a project that needs to mobile apps. I would like to use one machine for many customers. Been feeling out what MVS Tools can do for me, and I think it will work.Anyone want to share their setup?Thank youMark Laursen------------------------------Mark LaursenOwner/DeveloperComplete Computing Inc------------------------------

My name is Amey Rokde, and I'm a senior software engineer and architect at Rocket in the Pune office.  In this MVU session we covered how to use Kubernetes with the Rocket® MultiValue Integration Server (MVIS) to develop, maintain, and manage your UniVerse and UniData apps (D3 support coming soon). Kubernetes is an open-source platform for managing containerized workloads and services.  Code samples available here: https://github.com/MultiValue-University/MVIS-Kubernetes   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 #MVIS #DevOps #Modernization #Containers ​​​​​​------------------------------Amey RokdeSenior Software EngineerRocket Software------------------------------

Hi! I'm Brian Cram, Rocket Senior Technical Support Engineer, and I'm going to take you on a Rocket D3® security tour.  We'll be covering how to set up D3/Windows data encryption, D3/Windows Host Authentication, HTTPS for the MVS Toolkit, SSL for MVSP.    Be sure to check out next week's session where Tim Rude takes us through Securing D3 Data on Unix, along with me demo'ing how you can use mvWorkstation for secure remote access to D3 without a VPN.   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 #D3 #Security #Compliance #MVSToolkit #MVSP ​​​​ ------------------------------Brian CramSenior Technical Support EngineerRocket Software------------------------------

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!  I'm Tim Rude, Senior Manager of Software Engineering, and I'm going to take our D3 Unix users on a deep-dive look into D3 10.3.  Come see how you can upgrade to this version and take a closer look at the performance gains we have made.     In case you missed it, check out @Brian Cram's video series post last week for D3 Windows users looking to upgrade to 10.3.   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 #D3 #NewRelease #Upgrade #Performance ​​​​​​------------------------------Tim RudeRocket Software------------------------------

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

Hi everyone, my name is Stuart Mackenzie, Principal Support Engineer at Rocket, and I'm going to show you how you can easily migrate your existing U2 REST applications to the Rocket MultiValue Integration Server (MVIS).  We'll be comparing the differences between MVIS and U2 REST, highlight what you need to know to get started, demonstrate how to import existing U2 REST services into MVIS and review some of the added benefits of moving to MVIS.   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 #REST #MVIS #Upgrade #Modernization ​​​​​​------------------------------Stuart MacKenziePrincipal Support EngineerRocket SoftwareDenver CO------------------------------

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!