Groovy DBA

 How to refresh tst4ins4 Terminology Initialize = To create a new HADR cluster. Reinitialize = To repair an existing HADR cluster. Refresh = Same as non clustered databases, this means to restore the database from a different database backup image. 1. Start work with the primary (should be on db2tst602)     Verify it is the primary:     db2pd -db wctst10 -hadr 2. Stop HADR on primary:         db2pd -db wctst10 -hadr   <-- to verify it is the primary         db2 stop hadr on db wctst10            DB20000I  The STOP HADR ON DATABASE command completed successfully. 3. Stop HADR on standby:    [tst3ins3@db2tst601  ~] $ db2pd -db wctst10 -hadr [tst3ins3@db2tst601  ~] $ db2 deactivate db wctst10 DB20000I  The DEACTIVATE DATABASE command completed successfully. [tst3ins3@db2tst601  ~] $ db2 stop hadr on db wctst10 DB20000I  The STOP HADR ON DATABAS...

 The JAR file can be put anywhere on the server. When it is installed, the INSTALL_JAR command puts the JAR contents exactly where the database needs it. Also, ensure your JDK_PATH is setup. [dev2ins2@db2tst601  ~] $ unzip AESUtility.zip Archive:  AESUtility.zip   inflating: AESUtility.jar Put the AESUtility.jar anywhere and you can delete this file off the server once installed. To verify java is installed: $ db2 get dbm cfg | grep -i jdk  Java Development Kit installation path       (JDK_PATH) = /usr/opt/app/db2/admin/dev2ins2/sqllib/java/jdk64 (1) Connect to the database [dev2ins2@db2tst601  ~] $ db2 connect to wcdev2    Database Connection Information  Database server        = DB2/LINUXX8664 11.5.9.0  SQL authorization ID   = DEV2INS2  Local database alias   = WCDEV2 (2) Install the JAR file to the database [dev2ins2@db2tst601  ~] $ db2 "CALL sqlj.install_jar( 'fil...

 RESTORE DATABASE [identityiq_copy]  FROM  DISK = N'G:\SQLBackup\identityiq\identityiq_backup_2024_11_14_010001_0064765.bak' WITH  FILE = 1,   MOVE N'identityiq' TO N'I:\SQLData\identityiq_copy.mdf',   MOVE N'identityiq_log' TO N'J:\SQLLog\identityiq_copy.ldf',   NOUNLOAD,  REPLACE,  STATS = 10 GO

 check number of existing Connections/Max Connections in MySQL o check the number of existing connections for MySQL: Run the following query in MySQL Work Bench: select count(host) from information_schema.processlist; select * from information_schema.processlist; or show status where variable_name = 'threads_connected';   Check the max connection allowed by MySQL: Run the following query in MySQL Work Bench: select @@max_connections

  Hello Gillian, This is Jordy from Integration Tools team, I received your case today and will assist you. I have done some research for your question: Does PeopleSoft IB connects or has delivered integrations to work with Google Cloud Platform (GCP)? From IB framework perspective, we can manage to connect to any third party supporting REST and SOAP (PUB/SUB), you can build your own Service/Service Operation to integrate with Google Cloud Platform (GCP) if it does support REST and SOAP calls/requests. We do not have specific or delivered integrations for GCP. You can refer to the Integration Broker documentation in the following URL for 8.58: https://docs.oracle.com/cd/F44947_01/pt858pbr3/eng/pt/tibr/task_PeopleSoftIntegrationBrokerOverview-07659b.html Let us know if you have any comment or question. Regards, Jordy Yes, PeopleSoft can access a Google Cloud Platform (GCP) bucket. To achieve this, you need to configure the appropriate permissions and access controls on the GCP bucke...

 Hello Gillian, This is Jordy from Integration Tools team, I received your SR and will assist you today. Per your questions regarding REST, please find the following: (1) how can I tell if I already have it setup PeopleSoft delivered the REST, SOAP and Applications Services Framework to integrate with 3rd partys. (2) please point me to the detailed instructions on how to set it up We do not provide specific instructions to integrate with 3rd parties, but our base documentation is found in the following URLs: Understanding Managing REST Services https://docs.oracle.com/cd/G10810_01/pt860pbr4/eng/pt/tibr/UnderstandingManagingRESTServices-f77faf.html Understanding the Application Services Framework https://docs.oracle.com/cd/F44947_01/pt858pbr3/eng/pt/tibr/concept_UnderstandingTheApplicationServicesFramework.html (3) is there a more current technology REST, SOAP and Applications Services Framework are the current technologies that PeopleSoft delivers for integration with 3rd parties. ...