Retained across Save/Restore, Upgrade, etc Authorization requirements to change the configuration: *SECADM user special authority *OBJMGT and *USE to the target *USRPRF 10ġ2 QSYS2.SET_SERVER_SBS_ROUTING() Procedure Example: Construct a subsystem that will constrain the amount of system resources available to users who are known to execute ad hoc queries. The configuration detail is stored within the *USRPRF object. QZDASOINIT_SUBSYSTEM The subsystem to be used for incoming Database server connections for this user. QRWTSRVR_SUBSYSTEM The subsystem to be used for incoming DRDA or DDM connections for this user. AUTHORIZATION_NAME The user profile that should use an alternate subsystem for their activity. Alternate Subsystem Name The name of the subsystem to use Authorization name can be: User name Group name Supplemental Group name 9ġ1 QSYS2.SERVER_SBS_ROUTING View A new catalog QSYS2.SERVER_SBS_ROUTING is used to access the alternative subsystem user configuration. Server Name QZDASOINIT, QRWTSRVR or *ALL 3. Authorization Name The user profile name 2. Procedure QSYS2.SET_SERVER_SBS_ROUTING() Procedure Parameters: 1. This allows an IBM i administrator to relocate users into subsystems that are configured to meet user expectations or to protect overall system resources. Enhancement - A new procedure can be used to configure alternate subsystems by user and IBM i server name. SELECT * FROM QSYS2.LICENSE_INFO WHERE LICENSE_EXPIRATION <= CURRENT DATE + 14 DAYS 8ġ0 QSYS2.SET_SERVER_SBS_ROUTING() Procedure Dilemma - Database server connectivity is popular, but lacks granular systems management controls because all connections end up using the same subsystem (QUSRWRK). Keep the SQL Reference close by Like other crafts with repeated study and practice, your skills will improve 4ĩ QSYS2.LICENSE_INFO view The Work with License Information (WRKLICINF) command lacks OUTFILE support Implement improved Systems Management using SQL Return information about all licensed products - and features that will expire within the next 2 weeks. 2Ĥ Commands, APIs and tools Why consider SQL? With SQL-based options, consider which interface provides the best tool for the task Customer feedback SQL based interfaces has been very positive Besides being easy to use, SQL queries can be used for: Selection (WHERE clause) Ordering Grouping Joining Top n results IN, LIKE, NOT, and more SQE Unleash the power of the DB2 for i query engine 3ĥ Where to start? Get educated Understand the SQL coding environments: RUNSQL, RUNSQLSTM, Run SQL Scripts, STRSQL, CRTSQLxxxx, ODBC, JDBC, PHP, DRDA, etc Understand the query engine and optimizer options: Understand the SQL coding options: Explicit 3-part names, Implicit 3-part names, INSERT with remote subselect, CREATE TABLE with remote subselect, etc. This presentation contains proof of this point. SQL can be used on IBM i to easily extract deep details on nondatabase topics. SQL as a language construct does not need to be limited to database topics. ![]() SQL skills are either commonplace or customers have a desire to do more with SQL. Across the industry, SQL is recognized as a standardized and easy language to access the database. ![]() In many cases, customers are required to write specialized programs to exploit a new IBM i command or API. 1 SQL for the Modern System Administrator Robert Driesch IBM i ERP Development Support 0Ģ Commands, APIs and tools consider the options IBM i has a long history of creating Commands and APIs, so much so that we frequently conclude that further investment in these interfaces is the appropriate approach to deliver new capabilities to our customers The subject of this presentation is to explain the role of SQL based interfaces to allow non-db2 for i products and components to understand that an alternative / additional choice exists Development Cost, Value to the customer and Risk are the important factors to consider for any enhancement 1ģ Commands, APIs and tools Why consider SQL? Even though IBM i customers are used to commands and APIs, they are not always the easiest interfaces for customers to utilize (especially if from a client or the web).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |