About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Question & Answer
Question
How to delete or truncate MySQL binary files when using Gentran Integration Suite or GIS with MySQL as its database? *|* -02B27CBCD71715888525791900062BE7- *|*
Answer
Technote (FAQ)
Question
How to delete or truncate MySQL binary files when using Gentran Integration Suite or GIS with MySQL as its database?
Answer
For GIS that is installed on a Windows operating system please follow the procedures below:
Note: One may run the procedures below while GIS is still up and running.
1. Click Start > select Run > type cmd > click Ok
2. Change the current directory to the GIS installation directory\bin
???? Example: type cd c:\sterlingcommerce\si\bin and hit Enter
???? Verify that you are in the installation directory\si\bin folder;
3.? Type the following command next:
???? control_mysql.cmd truncate
The above procedure will help remove majority of the MySQL? master or binary files within the installation directory\si\mysql\data folder.
=================================================================
For GIS that is installed on a UNIX operating system please follow the procedures below:
Note: One may run the procedures below while GIS is still up and running.
1. Logon to GIS server as the GIS admin/user
2. Change the current directory to the GIS installation directory\bin
???? Example: type cd GIS/bin and hit Enter
???? Verify that you are in the installation directory/bin folder;
3.? Type the following command next:
???? ./control_mysql.sh truncate
The above procedure will help remove majority of the MySQL master or binary files within the installation directory/mysql/data directory.
| Segment | Product | Component | Platform | Version | Edition |
|---|---|---|---|---|---|
| Commerce | Sterling B2B Integrator | Data management - house keeping |
Historical Number
HTG2043
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SS73G6","label":"Sterling Total Payments for Financial Services"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
More support for:
Sterling Total Payments for Financial Services
Software version:
All Versions
Document number:
764619
Modified date:
12 October 2021
UID
ibm10764619
Manage My Notification Subscriptions