Rocket DevOps, MX, API, iCluster® – Solutions for IBM i™

Making significant changes to IBMi database files can take a lot of time, and typically that means a lot of DOWNTIME. Data and applications are often inaccessible to employees and customers, which can lead to delays, dissatisfaction and even lost revenue. The good news is that RDOi 10.2 (and the prior release, LMi 8.6) includes a great new feature that virtually eliminates downtime completely.  Check out the details here and reach out to us for help upgrading your product and your DevOps practice.------------------------------David AndrewsHead of Customer MarketingRocket SoftwareSouth Salem NY US------------------------------

Rocket DevOps core for Enterprise (Short name as RDOe)  10.2 on Linux is now supported with DB2 11.5.4.More details please refer to announcement------------------------------Tom LiSenior Manager, Software EngineeringRocket Internal - All Brands------------------------------

Please be noted that below products are compatible with IBMi version 7.5 DevOps core for IBM i 10.2 DevOps core for Enterprise 10.2 DevOps portal 10.2.0 More details please refer to announcement------------------------------Tom LiSenior Manager, Software EngineeringRocket Internal - All Brands------------------------------

Take a look at the announcement from product manager @Chris White detailing what's new in the latest release of Rocket DevOps. Highlights include improvements  to 'Change File While Active,' a feature that will dramatically lower system downtime, integrated testing features that improve developer productivity and code quality, and security enhancements. Rocket's Advanced Technical Support team is available to help you plan your upgrade to DevOps 10.2 or further unpack the release. If you have a year-end code freeze it's a great time to explore how an upgrade will improve your process and results.     ​------------------------------David AndrewsHead of Customer MarketingRocket SoftwareSouth Salem NY US------------------------------

Project Artifacts:     Project Settings                                         Publish SettingScreen Build                                              Client TypeCompiler Preferences                                                 IdentificationMX Desktop settings------------------------------Dennis KabeleleRocket Internal - All BrandsDenver CO US------------------------------

Understanding JWALK Project:1. Project files and what they are, preparation for the conversion. Directories and File types.2. Import JWALK files to the workbench and How JWALK was previously Deployed3. Common issues when converting JWALK projects to MX Desktop GUI      Missing files (for example Album)      Resolving issues that were current in Jwalk #RocketMX #workbenchInstallation #ImportJWalk# Understanding JWALK Project# Desktop GUI​------------------------------Dennis KabeleleRocket Internal - All BrandsDenver CO US------------------------------

Demonstrates how to install MX Desktop and use it to create a workspace, add a license, use MX Desktop Perspective, and create a new MX Desktop project#RocketMX # workbenchInstallation #ImportJWalk #pro​jectArtefacts------------------------------Dennis KabeleleRocket Internal - All BrandsDenver CO US------------------------------

In another tool, I was able to use a substitution variable to replace specific elements in an SQL statement.  For now I need to hard code the data library as the SP will be called without a library list.  Is this available and where do I find the list?  In this case, I need library group 2 from the setup definitions.  Then I would have PDQMST001 for ITG and ABCMST001 for QUA and PDN.      SELECT VSTATE AS State, ZIP, CITY, ad.VENDR, SEQN,VENDORNAME FROM LIBRARY1.FILE2PF AD JOIN LIBRARY1.FILE1PF NM ON (ad.VENDR = Vendorno) WHERE (wk_State = ' ' or wk_State = vstate) AND (wk_City = ' ' or locate(wk_City,upper(trim(CITY))) <> 0) AND (wk_Name = ' ' or locate(wk_Name,upper(trim(VName))) <> 0) ORDER BY state, zip; ​ FROM LIBRARY1.FILE2PF AD JOIN LIBRARY.FILE1PF NM ON (ad.VENDR = Vendorno) WHERE (wk_State = ' '

Suppose your organization has an identity provider which allows OIDC with the Authorization Code Flow.Wouldn't it be awesome to use this to automatically log on to your IBM system?All you need to have is Rocket MFA and use Rocket MX Web application with the new templates in 10.2.0 to configure this.This video will show how to configure Rocket MX Web with the new standard example files coming with 10.2.0.------------------------------Roger van ValenSenior manager, software engineeringRocket SoftwareDordrecht, The Netherlands------------------------------#MX #MXWeb #MFA #RocketModernExperienceWebedition #OIDC #SSO​​​​​​

After collecting your IBM i screens in the Rocket MX products, you may end up with hundreds of screens.Not all of these screens are equally used. There can be screens critical to all your end users, but some screens may not be used at all or only seldom.Process insights can give you the insights on your application usage.The latest version of Rocket MX Web (10.2.0) can leverage this information using the quickstart from insights. This way you can optimize the pages that actually matter to your end users by improving the user experience on these pages.This video will illustrate how to collect the track information from the hub to instantly create a web project and even do a smart build of the collected screens. Additionally statistical information will be shown of the usage and processes from the hub, which will help to quickly modernize the most used pages of your application.------------------------------Roger van ValenSenior manager, software engineeringRocket SoftwareDordrecht, T

Did you know you can speed up page rendering for pages with repetitive parts or static contents repeating for each page in Rocket MX Web?Examples are a side-bar menu or headers and footers that do not (often) change.Until now, this contents would be sent to your web client again and again for each new page send to the client.A new feature, introduced in version 10.2.0, gives the ability to configure pages to be a persistent include page, effectively caching that content.This new page type is ideal for pages that are included on multiple main and/or popup pages.This will not only improve performance, but because the contents is not re-send to the client the selection (state) will be remembered by the client too.This short video will explain this new feature and gives a demo on how to configure and use it.------------------------------Roger van ValenSenior manager, software engineeringRocket SoftwareDordrecht, The Netherlands------------------------------#Performance #MXWeb #MX #RocketMo

Interfacing the Lega suite from regular web page on button click, triggering JavaScript code, where using below code to create instance of the LegaOIS.LegaOISCtrl.1 and it is not working in Chrome as it doesn't support AcitveX object. Any solution or alternative ways ?var  LSObject = new ActiveXObject("LegaOIS.LegaOISCtrl.1");------------------------------Sai GolemOneMain FinancialEvansville IN US------------------------------

I have an ongoing issue.  Yes, I do have a case opened with Rocket Support, but I thought I would reach out to the user community on this topic to see if anyone else has run into this.We have over 125 PAIRS of IBM i LPARs, production (source) and DR (target) pairs.  That's a LOT of systems all running iCluster replication!  They all run basically the same application.  I am having an issue with one specific pair of source/target lpars when it comes to LFs being replicated.Our application has MANY LFs.  In this specific source/target pair, there are about 30 LFs that refuse to play nicely with iCluster.  They are flagged as OOS (out of sync) in the Latency screen (option 81 on the target side) with an NFD (not found) code.  This is the ONLY pair of systems that has an issue with this subset of LFs.  What have I done?  Well, I run a DMSNDOBJ (send object) on the source system to send the objects over to the target system.  I then do a WRKOBJ on the target system to make sure that the obj

We are interested in updating our linked X-Analysis repositories when an object is created or promoted using LMi. In release 8.2 B I see there are hooks for third party vendor products such as Hawkeye. Are there hooks in more current LMi releases? If not, what is the best way for us to accomplish refreshing our repositories when an object is created or promoted?------------------------------Mark HarrisonEngineering ManagerHealth Care Software IncWall Township NJ US------------------------------

We are interested in automating our use of LMi.  We do regular deployments at the QUA level twice a week and PDN level once a week in our organization.  What were interested - and some other products allow - is for the developer to put in a scheduled promotion request.  As in, the developer adds a promotion request for a specific date, aprovals are then requested / gathered in lmi, and then on the scheduled date and time, assuming all approvals are present, the task promotes and deploys automatically.  Is there any capability of this in Lmi?------------------------------John WeirichSoftware Architect for IBM iNelnetJacksonville TX US------------------------------

For many good reasons, the cloud, refactoring, and microservices are on everyone's minds, but application modernization can be a bumpy road. Success is more often achieved via thoughtful, data-driven approaches that help teams achieve early wins and build confidence with leadership and their internal customers. Join @Jeroen Van Dun on October 19th to explore the approaches and tools organizations should consider to drive successful modernization initiatives.Register here.  ​------------------------------David AndrewsHead of Customer AdvocacyRocket SoftwareSouth Salem NY US------------------------------

For many good reasons, the cloud, refactoring, and microservices are on everyone's minds, but application modernization can be a bumpy road. Success is more often achieved via thoughtful, data-driven approaches that help teams achieve early wins and build confidence with leadership and their internal customers. Join @Jeroen Van Dun on October 19th to explore the approaches and tools organizations should consider to drive successful modernization initiatives.Register here.  ​------------------------------David AndrewsHead of Customer AdvocacyRocket SoftwareSouth Salem NY US------------------------------

When preparing for an LMe (or any Rocket|Aldon product) upgrade, there is a step in the Installation/Upgrade Guide to verify the state of the database prior to running the actual upgrade.  This step exposes any potential data issues that might roll back an upgrade or cause delays.For LMe, the customer will run the AFFTVALCST command interactively to validate the constraint status'. Output will contain some of these typical messages:  AFF1519 Missing trigger APP_BU                                        on file AFFTCTL.APP_BU AFF1519 Missing trigger ARCIINS_BU                                        on file AFFTCTL.ARCIINS_BU AFF1519 Missing trigger ARCPDEF_BU                                        on file AFFTCTL.ARCPDEF_BU ……..   AFF1519 Missing trigger VPSET_BU                                        on file AFFTCTL.VPSET_BU AFF1519 Missing trigger VPSETXVP_BU                                        on file AFFTCTL.VPSETXVP_BU Press ENTER to end terminal session. These messages may seem

We recently heard from one of our Rocket DevOps customers on IBMi. They were seeing well over 5 minutes passing after startup before they were able to log in to RDOp. So they were wondering: Are there any further performance tuning tips or recommendations available ? We found that they had plenty of memory (12G RAM) and sufficient processing on their server which was dedicated to hosting RDOp and RDOi.   After local review of newer system options, we identified the configuration item that was causing the bottleneck for java processing on startup. Below is the excerpt now included in our installation guide for notes on the issue and the steps to resolve. ------------------------------ Jiqing Fan (Rico)Rocket Internal - All Brands------------------------------ Rocket DevOps portal - Performance considerations on startup Startup performance of Rocket DevOps on IBM i could be affected by the sharing mode on your logical partition. LPARs with shared processors can have a sharing mode of CAP

I am mostly certain that I used option 15 to set my programs to allow debug. I have verified this in *DEV and ITG. Now the program in QUA is not showing the debug source.  What am I missing? Yes, I can recompile for QUA into a temporary object, but I guess this means I would not be able to debug on the PROD system if that came about.   Is there a better solution to know I will always have the debug option?------------------------------David TaylorSenior DeveloperRange Resources CorporationFort Worth TX US------------------------------

I wanted to define this UDF as all SQL to make it easier to use with external platforms like SSRS. Is there a hard limit of one SQL UDF per source member?  See attached.  When I did the single, it worked and CREATE passed.  When I tried various ways to code more than one UDF in the same source member, it failed every time.  I await the wisdom from my companions on the journey. ------------------------------David TaylorSenior DeveloperRange Resources CorporationFort Worth TX US------------------------------

We have had times when we wanted to review the documents for a deployment set.  Now, I am sure there is a better way, but at the time I was new. We took this simple command and wrapped it in a CL to be able to pass in the deployment set.  Then we added a command--THISDEPLOY--to be able to call the CL quickly.  Now, when we want to see what is happening or has happened, we type THISDEPLOY 000000 where 000000 is the number for the deployment set WRKSPLF SELECT(ALDONCMS *ALL *ALL &DEPLOY)------------------------------David TaylorSenior DeveloperRange Resources CorporationFort Worth TX US------------------------------

I'm pleased to announce the release of Rocket DevOps portal & test v 10.1.3 Rocket DevOps is the next evolution of Rocket Aldon ALM. Rocket DevOps portal is a management and orchestration console that provides an easy-to-use web interface for Rocket DevOps operations. It supersedes Rocket Aldon Ops portal and provides a common interface for other new and planned modules. New dashboard capabilities and a consolidated Report Manager are included together with remote system status monitoring. Highlights of this release include: New audit report scheduler Enhanced audit report parameters Email server configuration support Fast download of Task reports New dashboard shortcut options Safari browser support Rocket DevOps test v 10.1.3 UI supports these additional features**:  Create, edit, view, report test cases Extract & obfuscate test data from production systems Record and playback interactive sessions Submit & monitor batch jobs Execute and monitor remote commands on IBM i

We have inherited an SQL file definition from previous developers.  At the time, they made a good decision to move a file from DDS to DDL.  This file is a reference file and has many, many fields. When we go back into the source member to change a set of fields from 9,0 to 12,0 we end up with "SQL statement too long or complex."  The source member is a *TABLE/SQL.  I tested using ALTER TABLE from STRSQL and that all worked.  Now, what type of object do I create in Aldon so I can list all the fields to be updated with the new definitions and be able to run that source member tied to the original file. Yes, the problem is the CREATE TABLE failing.  When I tried to pull the LABEL statements out, it still failed. ------------------------------David TaylorSenior DeveloperRange Resources CorporationFort Worth TX US------------------------------

One of the first tricks I learned as a newbie System/38 developer was from Jim Sloan at a COMMON conference in the 80's  (whoa...talk about "way back"!). The tip was this: "If you need a program to process a database file that just needs to exist for the life of the job, create that file in library QTEMP. Once the job ends, the OS automatically deletes this library as well".  Super-slick. So, what's the challenge? The challenge is compiling this program. You have to create the file in your interactive session's QTEMP and then compile your program interactively (not in batch) in order to find that file in that same job's QTEMP library. That's not an impossible challenge, but what if you have LMi and you need to move your program up the workflow using LMi's promotion? These all get submitted to batch! We get this question quite often, so I thought I'd give everyone some ideas. My best idea it this: create all of your "QTEMP files" in a special library, e.g. LMIQTEMP. Now add that library