Rocket® U2 | UniVerse & UniData®

I attended the last MV Roadmap session, & it was mentioned that MV BASIC for Visual studio would be released at the end of March.   I would be very interested to try it out, once it is released, so can someone from Rocket please advise once it is available, thanks!MARY MULLANE

Hi all,I'm posting the answers to the UniData and UniVerse sections of the quiz here. Note that SurveyMonkey doesn't make it easy to share this so you have to scroll through many pages of information just to see the right answers. A lot of the stats are just plain wrong, so focus in on the table at the bottom of each page/question. The green check mark shows the right answer while the table and chart above show the distribution of responses.Thanks again to all who played, and let me know how we can make your future experiences as a forum member even better, whether it be more events like this, specific 'how-to' content, people you want to hear from, etc.Dave ------------------------------Dave AndrewsHead of Customer EngagementRocket Software------------------------------

Thanks for the replies Yunpu & Christian, I can now see the .rmv directory, & I've been able to configure my Server connection details OK.MARY------------------------------Mary MullaneAnalyst/ProgrammerEBOS GroupMelbourne Australia------------------------------

If you are reading this post in the daily digest you are ready to plan MV Madness. Follow this link to play if you haven't already. Hopefully it's fun and bit educational, and you could win stuff. The quiz closes at midnight EST on Wednesday.Good luck to everyone!------------------------------Dave AndrewsHead of Customer EngagementRocket Software------------------------------

I'm attempting to setup EDA on a UV 10.2 system.  I have setup an ODBC data source that is able to connect to SQL Server without any difficulty.  So now I'm in the EDA Schema Manager and attempting to setup the EDA Data Source with the same credentials that worked in the ODBC connection manager.  And I'm getting this error when clicking on the "Test" button:No clue what this means.  The DSN has the ODBC data source name, and that data source does pass the connection tests successfully.  What am I missing?

My name is Cheng Jiang, and I am a Rocket Software Engineer III in the Dalian office.  In this series, we'll take a close look at Automatic Data Encryption (ADE), a free feature you can enable today in the UniVerse and UniData products to help secure your data at rest.  It's important to understand the risks of not securing your data, as 90% of companies that experience data loss go out of business within 2 years, according to Gartner.    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 ​​​​​------------------------------cheng jiangC/C++ developer MV EngineerRocket SoftwareDalian------------------------------

Hi allI built a Python wrapper for the Intercall library to access an Universe database.Now I'm porting my utilities so they can use the native uopy module. The work is pretty straightforward but I don't find the equivalent call to ic_fileinfo ic_fileinfo (key, file_id, data, buffer, buffer_size, code)​ Is there a way to do this using pure uopy calls or do I have to build a custom UniRPCPacket to simulate the Intercall function?

Is posible setting up a com port to baud rate bigger than 19200?I saw Basic TTYSET and TTYGET but i don't find an explanation of EXTA or EXTB.Someone have any clue?Thanks.------------------------------Sergio PerinEngineerBaseware Systems------------------------------

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