What's new- System Management

Completed sprints and identified features are in bold text.

Summary

The work for System Management is distributed between Painkillers and Eagles. This section summarizes the features being developed to give a unified view of the 6.2 release.

Permissions!

Import Wizard

Export Wizard

Packaging Wizard

Column Population (Optimization)

RAP Form

Migration Wizard

Fix My Schema

System > Tools

Dynamic system settings replace prconfig.xml -- prconfig.xml definition

Proj-436 Pain Killers Carl

GRP-20648—Sprint 6.2.1

GRP–19703—API that gets vendor-neutral schema metadata for an app
Doc Impact: Supporting processing—No documentation impact.
GRP-19706—Import Wizard supports Bundles with a schema archive
1. Import Wizard detects Schema Archive (SAR) in Application Bundle
2. Asks the user if they would like to apply it.
3. Vendor neutral schema in the SAR is displayed to the user.
Doc Impact:

Property Exposure and Schema migration

GRP-21276 Sprint 622

Property Exposure and Schema migration

importing a PAR file (or a ZIP with RuleSets) with new import wizard, it can display two screens (one for inserts the other one for updates) listing the instances in the package sorted by: Load Order, RS Name, RS Version, Class, Instance name or key,

import wizard to show me a the classes and tables that need schema changes and present a button that show me in the screen the DDL for all the changes and gives me the chance of download it as . SQL file,

view the database specific DDL delta, and have the changes applied, when I am importing an Application Bundle that contains a SAR file.

Import Export landing page

GRP-22021 Sprint 623

The Import gadget supports multi-application bundles. Application bundle

Import Gadget - Completing the Import ZIP file options

A product rule can now include JAR files. Product rule form - Completing the Contents tab

import wizard has choices for each app in a multi-application bundle

import wizard replaced with a shortcut button

GRP-22890 Sprint 624

GRP-21288-1 - Import Wizard has choices for each app in multi-app application bundles
Import wizard supports the same import choices that it supports in single applications imports, but iterates over each app in the bundle to select my import choices for each of them.

GRP-23435 Sprint 6.2.5

GRP-22801 - At JAR import type codeset name and version
If JARs being imported from the file system into the PRPC database do not have a defined codeset, user can enter codeset name/version in which the JAR will be placed or assign it to an existing one in the system (if not specified the default is the active Customer codeset)

GRP-22464 - Executing necessary repopulations on import
Execute repopulation jobs at package import time if the package is bringing/applying column exposures on classes with instances, so repopulations previously executed on the source system get recreated on the target. Add a Yes/No legend to start repopulation and a link to job dashboard

GRP-23361 - DB names must exist in target
The absence of the DB names in target interrupts the Import wizard with a warning message

GRP-23922 Sprint 6.2.6

GRP-22802 - Import takes AppBundles with multiple code-archives and multi-codesets
Import packages containing multiple jars in multiple codesets ( CPMFI Solution Frameworks). Show view of self-contained packages being imported.

GRP-23864 - Optionally allow optimization of property after import
Show list of access groups on the system. Allows user to pass an access group from the rules space that allows the column population functionality to work for top-level properties.

GRP-24389 Sprint 6.2.7

GRP-19318 - Export all workbaskets associated with application
Using the application packaging wizard, get all workbaskets used by the application.

GRP-241100 -
Importing an app bundle that contains RDI's or External mapping, ensure the column populator runs with the right access group so that declaratives are generated correctly
Column population (for all jobs as a single batch) should be offered as an option to be run as the last screen in the import wizard. In this new screen a check box reading "Run necessary property/column repopulation jobs in background" will decide if repopulation will run or not, and if checked a datetime field will give the option to schedule it for later time (the default will be the current time). When the user press the "Submit Job/s" button the Repopulations job dashboard should be open, so the user can see the status of all the jobs.

GRP-21652 - Install/upgrade process should display connection info on verify
On page with verify connection button, display the d-a-system-setting or the highest version of the PRPC stack.

GRP-24748 - Sprint 6.2.8

GRP-24250 - use the Application Packaging Wizard to store the instance of the RAP rule being created in any open RS in the system or (by default in) a PRPC-shipped locked RS called ApplicationMigrations 01.01.01, so the RAP rule and its Rs are added to the RAP being created.

GRP-24753: Column population for External Mapping on Import

When importing an app bundle that contains External mapping, ensure that user runs the column populator with the right access group so that declaratives are generated correctly and things just work. (Video attached to GRP)

Specify Access Group in Import wizard before kicking off import.

GRP-24754: Column Population on Import - Scheduling

New last screen in the import wizard offers column population (for all jobs as a single batch) should be offered as an option. Check box reading "Run necessary property/column repopulation jobs in background" with options Skip, Run Now or Schedule for later. Schedule displays date selector. When the user presses the "Submit Job/s" button the Repopulations job dashboard opens.

GRP - 24110-1: Run Column Populator on right applications on import

If Import contains exposed columns or Declare Indexes in source app bundle, column populator runs on the right applications in the target system to conform. User specifies access group.

GRP - 25493: Build Rule references to RuleSets during application validation

The Rule-Application instances are currently not capturing RuleSet references during validation in order to allow the user to change the RuleSet to which the Application belongs. Update Validation to build these references for use by the Re-indexer.

GRP-25409 - Sprint 6.2.9
GRP-22316: Imp Wiz has a new "conflicts" screen for integr. data instamces

The import wizard presents a page (when opting for advance/slow mode) that shows all the data records associated to the integration rules and contained in the application/s in the package. Users de-select the ones they do not want to import. In fast mode the screen will be forced to be displayed only if the same records exist in the target system as it happens today with other conflicts. Note: Data instances associated with Integration resources reference servers/user ID's/pwds etc that may not be appropriate in the system that you are moving the application to.

GRP-24532: Preview of the migration package anatomy

Bbefore the actual import or export of the package show a preview of its content, so users can uderstand what they are migrating. Preview screen included in:

1) Import Wizard - As a new link in 3rd screen

2) RAP Form - add a preview package (this time the popu up with instances are links to the forms of those instances).

3) Application Packaging Wizard - Last screen - Add a Preview Package button.

GRP-25412: Enhance Upgrade wizard to revalidate and save Application rules

Verify references to associated RSs in the target system are generated.

GRP-26301 - Sprint 6.2.10

GRP-25108: Export Integration Resources with App Packaging Wizard

The App Packaging Wizard includes a new screen similar to the Operators and Work Baskets, that shows all the instances of the Data-Admin-Integration... in the system (ordered by class, and in pages. Users can check the ones to include in the RAP to speed up the integration data instance selection process directly out of the wizard without opening the RAP form.

GRP-26354: App Pack Wizard gathers Data Table classes and instances

the App Packaging Wizard offers the inclusion of data tables and their instances (with option to opt out) to the RAP, so users can move important constants in their system or applications to the target environment.

GRP-24170: Altering the DB2 z/OS Table Page sizes

As a DB2 z/OS PRPC user I want my tablespace page sizes to be 16k for rule tables, so that I can expose columns without a fear that I will blow the page size immediately causing complex and time consuming DBA utialiites to be run.

GRP-26955 - Sprint 6.2.11

GRP-26302: Export Data-Admin instances with App Packaging Wizard

App Packaging Wizard includes a new screen similar to the Operators and Work Baskets, that shows all the instances of the Data-Admin-... (excluding the integration ones) in the system (ordered by class, and in pages) so users can check in the ones to include in the RAP to speed up the data instance selection process directly out of the wizard without opening the RAP form.

GRP-26303: Import wizard final page lists imported data-admin instances

The Import Wizard, in step-by-step mode when the import finishes and before showing the repopulation job screen, displays a new screen step that shows all the imported data instances (not related to integration settings) with a link to their rule forms, so i can tweak their values after the load of the package.

GRP-27581 - Sprint 6.2.12

GRP-26303-1: Import wizard final page lists imported data-admin instances

After the import finishes, the Import Wizard in step-by-step mode before the repopulation job screen, displays a new screen step that shows all the imported data instances (not related to integration settings) with a link to their rule forms, so i can tweak their values after the load of the package. This could be the final screen in the wizard if the user there are not repopulation jobs to run.

GRP-24246: Imp Wizard final page lists links to imported integr data instances

After the import finishes, the Import Wizard in step-by-step mode before the repopulation job screen, displays a new screen step that shows all the imported data instances related to integration settings with a link to their rule forms, so i can tweak their values after the load of the package. This could be the final screen in the wizard if the user there are not repopulation jobs to run.

GRP-27566: Filter by sub-set of classes in the App Pack Wiz

In the Application Packaging Wizard, the last non-integration screen/step shows only Data-Admin-system-Setting instances (or a finite set of classes), so the selection is more narrowed.

GRP-28358 - Sprint 6.2.13 (in progress)

GRP-27569: Importing views

When importing a ZIP, PRPC creates the views included in the package in the target system or stops and warns if the views use any vendor specific feature not supported in the target DB vendor, so the PRPC migration covers most of the DB entites used by common PRPC apps and Frameworks. Cross vendor. If the views in the package cannot be created the error mesage should show the view's DDL so the user can try applying it manually and the import process should not continue. In the page in which we show schema changes and tables we show potential view conflicts with checkboxes for skip or override choices.

Proj-581 Eagles Hyderabad Carl

GRP-20821 Sprint 621

Property Exposure and Schema migration

GRP-15429 -- control by role access setting which access groups can and cannot have the rights to have all these auto exposing/population capabilities available,

GRP-18309 Property Optimization Jobs -- new menu choice on right click of Application explorer

-- About the Property Optimization wizard

-- Context sensitive help: Help1 Help2 Help3

-- About the Application Explorer

GRP-21111 static assembly assembles additional stuff (all 4 input types??)

-- Static Assembler

GRP-21528 Sprint 6.2.2

GRP-20958 - Using the Property Optimization - for non-work classes, exposing a property in a class also exposes that property in (?parent? child?) classes that share the same database tables.

Identify orphan columns

GRP-22291 Sprint 6.2.3

Schema options to be applied automatically (without UI choices*) if

A) The system-level setting database/AutoDBSchemaChangesWithoutChoice is set to true,and

B1) The production level is 1 or 2,

or B2) If the prod level is 3,4, or 5 but the operators have the privileges: pxPropertyToDbColumnOptimization and pzClassToDbTableOptimization, so the user will have all the Table Mapping, Column Exposure/Population, and Schema Migration features transparently available.

However, <env name="database/AutoDBSchemaChanges" value="false" /> can turn off the whole schema import facility regardless of production level.

GRP-23086 Sprint 6.2.4

As PRPC user, I want the import wizard to support the same type of import choices that it supports in single applications imports, but do it as well for application bundles that contain multiple apps, so it iterates over each app in the bundle and I can select my import choices for each of them.

App bundles can have multiple par files -- if so, should show selective import process for each archive.

GRP-23454 Sprint 6.2.5

As PRPC application/framework developer I want to import JARs from the file system into the PRPC database and if they do not have a defined codeset name/version I want to create a codeset name/version in which the JAR will be placed or assign it to an existing one in the system (if not specified the default is the active Customer codeset), so I have the freedom of classifying the JARs under the right codeset

GRP-23922 Sprint 626

GRP-24065:UI for job scheduling
UI for property optimization jobs

GRP-24066 - the UI for column indexing in fix my schema
Wizard should display following columns listed for this section. 1) Table 2) Column 3) Existing Index Count 4) Usage Count 5) Index Type and 6) Create option. User should be provided with checkbox for 'Create' option.

GRP-24554 - Sprint 627

GRP-24022: Refactor permissions for Mapping. Optimiz., and Schema Imp/Exp
[email protected] gets OTB privileges for SchemaManagement in prod level 1 and 2. To give access to these features in prod levels 3 to 5, you must explicitly associate the privilege with the respective role/s. To restrict the access to these features completely, I need to remove the priviliges from the desired roles.
Features to protect with this privilege:
1) Creation of dedicated tables during Class creation.
2) Display of the "optimize for filtering" option in the right-click float menu over properties in the App Explorer.
3) Display of any schema related UI element or schema generation functionality during Import.
4) In the case of Export, the schema will be catured always w/o privilege restrictions, it is just that if you do not have the privileges, you should not see schema-related UI elements or messages.

GRP-25506 - Sprint 628

GRP-24696: Packaging, Export, and Import Landing Page
3 menu options out of the Application->Import&Export PegaButton Menu; which matches with the Import&Export landing page and its 3 tabs: Packaging (default), Export, and Import (in that order), so the first one hosts the PackWiz in an IFRAME, the second one runs the current Export functionality, and the third one host the Import Wizard in an IFRAME as well.

GRP-25255: Associate privileges to Fix my schema
Restrict the access to Fix my schema as they involve schema changes. The privileges should fall into the explicit category of the schema managment privileges

GRP-21287: Link to the app packaging wizard from app structure landing page
export my appliction directly form the Application>App Structure>Rulset stack landing page, so I can get directly to the app pakaging wizard pre-filled with the appropiated defaults

GRP-25498: Import Wizard as part of the Import & Export landing page

Deprecate the old Import feature so the new Import Wizard is the only import option and the wizard shows up on the Import & Export landing page (in the Import tab). The old import functionality cannot be reached anymore from any UI. Switching between Import and Export tabs and returning to a previously started Import wizard should make it to restart. Leaving the tab or closing the Import & Export landing page before getting to the load of the rules should interrupt the Import wizard flo.

GRP-25506 - Sprint 628

GRP-24022-1: Refactor permisions for Mapping. Optimiz., and Schema Imp/Exp

As [email protected] I want to get OTB privileges for SchemaManagement in prod level 1 and 2, and if I want me or other administrators to get access to these features in prod leves 3 to 5 I need to explicitly associate the privilege with the respective role/s. In the same maner, if i want to restrict the access to these features completely, I need to remove the priviliges from the desired roles.
Features to protect with this privelege:
1) Creation of dedicated tables during Class creation.
2) Display of the "optimize for filtering" option in the right-click float menu over properties in the App Explorer.
3) Display of any schema related UI element or schema generation functionality during Import.
4) In the case of Export, the schema will be captured always w/o privilege restrictions, it is just that if you do not have the privileges, you should not see schema-related UI elements or messages

GRP-25506 - Sprint 6.2.9

GRP-26480: Log all changes made through fix my schema and property exposure to pr_changelog table, including columns deleted,tables dropped and index created through fix my schema and column creation through property optimization

GRP-various: Check details in sprint for stories "Karim's review"

GRP-26549: Offer optimization at property creation time

As PRPC developer, when I create a new propety, the New Property form, should offer an option for optimization, so I know early in the process that Properties may need to be optimized for filtering. This feature does not need repopulation since there are no instances with values for a property that does not exist yet.

GRP-26549 - Sprint 6.2.10

GRP-26727: table creation with refactoring tools

use the PegaButton->System->Tools->Refactor Rules options and the PegaButton->DataModel->Tools->CloneClassGroup feature, I want to make sure that the tables are creted/renamed/re-mapped accordingly, so the mapping between classes and tables remain solid.

GRP-26745: Fix my schema wiz renamed and relocated

wizard called "Database Schema Optiimization" in its pegabutton menu, landing page title, landing page tab label, and in any button, link, or help reference that leads to the wizard (today called) "Fix my Schema" wizard, so it can be reached from thePegaButton->DataModel->Tools as a 3rd option below the two existing menu options

GRP-27087: Schema Change Log landing page

Data Model->Tools->Database Schema Change Log (available via the same "explicit" privilege used in Fix My Schema) shows the Tables created by PRPC from Class->New, the columns/indeces/mappings that where created by the Prop Optimization wizard, the changes made through the Database Wizard, schema changes introduced on imports, etc. so i can get a log of the alterations to the schema.

GRP-27873 - Sprint 6.2.11 (in progress)