Integrated Analytics System 1.0.24.0 release notes (November 2020)

WORKAROUND:

1. AFM-DR replication is down after upgrading to 1.0.24.0.

   Run apdr status --replqueue to confirm whether the filesets are in the Down state or not.

   WORKAROUND:

   If the head node on the primary system is rebooted, follow this steps to bring filesets to the Active state. If filesets remain Inactive and or Down, subsequent snapshots are going to fail.

   1. As the apuser, determine which filesets are inactive after the GPFS recovery:

   apdr status --replqueue

   Example:

   [apuser@node0101 ~]$ apdr status --replqueue
   Directory                                                         Queue Status        Sync Status
   /opt/ibm/appliance/storage/head/home/db2inst1/db2/keystore        Down                    Unknown
   /opt/ibm/appliance/storage/data/db2inst1                          Ready                   In-Sync
   /opt/ibm/appliance/storage/local/db2inst1                         Ready                   In-Sync
   /opt/ibm/appliance/storage/scratch/db2archive                     Down                    Unknown
   /opt/ibm/appliance/storage/head/db2_config                        Down                    Unknown

   2. Touch a file in the directories that are Down in step 1:

   cd /opt/ibm/appliance/storage/scratch

   touch abc.txt

   Example:

   [apuser@node0101 ~]$ cd /opt/ibm/appliance/storage/scratch
   [apuser@node0101 scratch]$ touch abc.txt

   Repeat step 2 for all the filesets that are showing as Down.

   Note: For the head partition, you need to touch the file as the root user.
   3. Verify that all filesets are back to Active:

   apdr status --replqueue

   Example:

   [apuser@node0101 ~]$ apdr status --replqueue
   Directory                                                         Queue Status        Sync Status
   /opt/ibm/appliance/storage/head/home/db2inst1/db2/keystore        Ready                    In-Sync
   /opt/ibm/appliance/storage/data/db2inst1                          Ready                   In-Sync
   /opt/ibm/appliance/storage/local/db2inst1                         Ready                   In-Sync
   /opt/ibm/appliance/storage/scratch/db2archive                     Ready                    In-Sync
   /opt/ibm/appliance/storage/head/db2_config                        Ready                    In-Sync

1. db_size

   db_size is failing to calculate BLUDB, SUM (SCHEMA), OTHER METADATA/CACHE/CONFIG FILES size while running from the client container.

2. db_migrate_iias

   db_migrate_iias fails when you run it as the AD user from inside the container.

1. Replication of external tables (files)

   Replication of external tables (files) is not supported. External tables display in the console as tables that you can add to a replication set and have an N value in the Viable key column, but you should not select these tables. If you do select an external table, the console shows error ASN7527I after the set finishes configuring and you must manually start the set."

2. SSL certificates

   After you upgrade your Db2 source or target databases, you must take steps to ensure that the correct Secure Sockets Layer (SSL) certificates are in place at the source and target databases and that the trust target certificate process is run. For more information, see this link.

1. To set up the Grow on Demand feature for IAS, contact IBM Support. IBM Support might reference this document.
2. The apgodmgr --set command returns permission denied error.

   Traceback (most recent call last):
     File "/usr/bin/apgodmgr", line 255, in <module>
       main()
     File "/usr/bin/apgodmgr", line 245, in main
       rc = set_params(args.set, unknown_args)
     File "/usr/bin/apgodmgr", line 154, in set_params
       transfer_file(node, GODFILE)
     File "/usr/bin/apgodmgr", line 104, in transfer_file
       sftp_client.put(filename, filename)
     File "/usr/lib/python2.7/site-packages/paramiko/sftp_client.py", line 676, in put
       return self.putfo(fl, remotepath, file_size, callback, confirm)
     File "/usr/lib/python2.7/site-packages/paramiko/sftp_client.py", line 634, in putfo
       with self.file(remotepath, 'wb') as fr:
     File "/usr/lib/python2.7/site-packages/paramiko/sftp_client.py", line 327, in open
       t, msg = self._request(CMD_OPEN, filename, imode, attrblock)
     File "/usr/lib/python2.7/site-packages/paramiko/sftp_client.py", line 730, in _request
       return self._read_response(num)
     File "/usr/lib/python2.7/site-packages/paramiko/sftp_client.py", line 781, in _read_response
       self._convert_status(msg)
     File "/usr/lib/python2.7/site-packages/paramiko/sftp_client.py", line 809, in _convert_status
       raise IOError(errno.EACCES, text)
   IOError: [Errno 13] Permission denied

   To resolve the issue, contact IBM Support. IBM Support might reference this document.