Rocket MultiValue

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

I just discovered (joyfully) that we could print and email (by way of Cups-PDF post processing options) any D3 report to a PDF file by defining a shared printer that outputs its contents through Cups-PDF (we use D3/Linux).  The printer also respects the CUPS options passed to it (I have only tested -o landscape and -o cpi=17 so far).Coming out of this discovery, here is an initial list of wish I hads:The ability to directly mail the reports to the consumers rather than having to forward them from a single central mailbox.The ability to inject the title of the report into the PDF document and also name the resultant file for ease of identification.The ability to colorize elements of the report.  I guess this would have to come from some DEVICE file definition.The ability to archive the reports based on title and date/time generated.Any help in respect of the above would be appreciated.Finally, is ROCKET planning to develop anything in this regard.Best regards and keep safe,Vin

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

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

Rocket® MultiValue Integration Server (MVIS) 1.3 empowers developer teams to leverage modern languages and frameworks to access MultiValue data and business logic, allowing enterprises to join and thrive in the API economy and the cloud. This overview explains how. Happy to answer any questions you have! ------------------------------Amey RokdeSenior Software EngineerRocket Software------------------------------

#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

MultiValue Integration Server version 1.3.0 has been released on March 10 2021 for the below platforms/versions:AIX POWER       7.1,  7.2Amazon Linux       2CentOS       7,  8Oracle Enterprise Linux x86       7,  8RedHat Enterprise Linux Intel       7,  8SuSE Linux Enterprise Server Intel       11.0,  12.0,  15.0Windows       Windows 10,  2012,  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 u2askus@rocketsoftware.com.

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

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

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

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