how to add SQL option to existing 19.0 IDMS

Document ID : KB000109289
Last Modified Date : 02/08/2018
Show Technical Document Details
Question:
We upgraded to IDMS 19.0 but had not previously used the SQL option.
What steps are needed to add the SQL option to a CV that was installed/configured without it?
Answer:
You already have IDMS installed from the CAISAG.CONFIG(VARBLIST) so you can use that VARBLIST with the following changes to do the add-on configuration of SQL option.


For the ADD-ON of SQL 

Set BEGINMEM = SQL 
GJUPGRAD = NO

 In the VARBLIST search on 
ADD-ON and it should take you to this section: 
* ADD-ON CONFIGURATION 
*--------------------------------------------------------------------- 

* This section is for an Add-On configuration. 

specify YES for GT0ADDON, ADDSYSQL and ADDQDEMO : 

GT0ADDON = YES          CA IDMS SQL 

ADDSYSQL = YES         Do you want to create a SYSSQL catalog component?
*                      It is added to the APPLDICT dictionary. (YES/NO) 
*                                                                       
*                      Do not specify YES if you already have the SYSSQL
*                      catalog component.  Note that you already have   
*                      the SYSSQL catalog component if                  
*                         (1) You have installed the CA IDMS SQL Option 
*                         (2) You have installed CA IDMS Visual DBA     
                                                                        
ADDQDEMO = YES         DO YOU WANT TO INSTALL THE SQL VERSION OF THE    
*                      Employee Skills Demo database? (YES/NO)          
*                                                                       
*                      Specify NO if you have already installed the     
*                      SQL version of the Employee Skills Demo database.
*                      It has not changed since Release 12.0.           


Run CAISAG with these modifications and it will generate SQL00 through SQL18 members in your CAISAG.CONFIG to add SQl to your CV. 
NOTE:  Review all jobs to be sure the updates are to the correct DMCL, Dictionary and DBnames for your environment
 

SQL02 has the source to enable SQL in RHDCPINT. Uncomment this: 
* #DEFPINT SQL CA IDMS SQL 
Be sure not to comment out what was previously uncommented. Chances are you have a separate JCL for RHDCPINT which is where you should uncomment #DEFPINT SQL. Basically run these SQLnn jobs to add SQL to your CV. 

I did an add-on configuration of SQL to my test CV also. Reviewing the SQL specific jobs this is what I see: 
First keep in mind that the SQL option software is already installed in CAGJLOAD. These jobs are enabling the use of SQL and configuring it on the CV. 

00 and 01: There's nothing to do. 

02: Copies the updated RHDCPINT source to CUSTOM.SRCLIB(RHDCPINT) and link statements to CUSTOM.LNKLIB(RHDCPINT). 

03; Does the assemble and link of RHDCPINT. Verify that all IDMS products that are already enabled have the #DEFPINT macro uncommented along with #DEFPINT SQL. 

I have an assembly and link JCL for RHDCPINT that I used just to include #DEFPINT SQL to the list of uncommented/enabled products. I used this JCL and skipped 02 and 03. 

04: There's nothing to do. 

05: Allocates the datasets for the SYSSQL, PROJSEG and SQLDEMO segments that will be added to the DMCL in the 08 and 15 jobs. 

06: You could skip this job because you should have executed it when the base install was done. It only updates members such as IDMSDDDL, IDMSBCF etc. I'd recommend running it again. 

07: There;s nothing to do. 

08: Rebuilds the DMCL to include the SYSSQL segment and also the DBname table to include the SYSSQL segment in the APPLDICT DBNAME entry. It may be a different DBNAME entry for you. 

09: There's nothing to do. 

10: Formats the SYSSQL segment, adds TABLEDDL and VIEWDDL to this segment. 

11, 12, 13, 14 : There's nothing to do. 

15: Adds SQLDEMO segment to the DMCL, formats the areas for this segment. 

16: There's nothing to do. 

17: Copies the task and program statements to sysgen for the SQL option, also does a PRINT SPACE for the segments. 

18: There's nothing to do.