IBM Sterling File Gateway v6.2 Administration Questions and Answers
Which kinds of SQL statements can the JDBC Adapter in IBM Sterling B2B Integrator handle as part of a business process?
Options:
Only map-specific queries
SQL statements, stored procedures, and stored functions
Predefined queries provided by the adapter
Update statements only
Answer:
BExplanation:
The JDBC adapter lets a business process work with any JDBC-compliant database. Through its associated services, a business process can submit ordinary SQL statements such as select, insert, update and delete, call stored procedures, and invoke stored functions, and then use the returned result sets or output parameters in later steps. Connection details, including the driver, URL and credentials, come from a JDBC connection pool defined for the adapter, while the statement itself is supplied by the business process. This flexibility is why the adapter is used to read reference data from an external system, write transaction results back to an application database, or run database-side logic as part of a workflow. The adapter is therefore not limited to queries that are tied to a translation map, and it does not offer only a fixed set of predefined queries. It also does not restrict a business process to update statements. Because statements run with the privileges of the configured database account, administrators should grant only the access the business process requires and should avoid placing credentials in business process definitions.
Which component permits the use of User Exits?
Options:
WebSphereMQ Suite Put Service
JMS Send Service
Mailbox Add Service
Message Add Service
Answer:
CExplanation:
User exits are points at which customers or partners can link their own Java code into predefined product operations. In Sterling B2B Integrator and Sterling File Gateway, the mailbox component exposes user exits that are hooked into message add, message delete and message extract operations, and these were introduced during the 5.2 release stream. A class that implements the relevant Java interface is registered in MailboxUserExits.xml in the properties directory, under the matching user exit bean. The code then runs whenever a message is placed in a mailbox through the Mailbox Add service. This lets an implementer add custom logic such as allowing or blocking file extensions, checking file names or upload times, or starting a business process immediately when a message arrives instead of waiting for the scheduled routing rule evaluation. The WebSphereMQ Suite Put Service and the JMS Send Service are transport services that hand messages to external queues. They do not expose a comparable user exit hook. The Message Add Service is also not the documented user exit point, so the Mailbox Add Service is the correct choice.
What happens when a mailbox is assigned to a multi-user group?
Options:
Every user with the assigned group can only view the contents of the specific mailbox.
Every user with the assigned group can only add to the specific mailbox.
Every user with the assigned group can just extract files from the specific mailbox.
Every user with the assigned group can add or extract files from the specific mailbox.
Answer:
DExplanation:
A mailbox in Sterling B2B Integrator is a repository for messages exchanged with trading partners, and access to it is controlled by permissions that can be granted to individual users or to user groups. When a mailbox is assigned to a group, every member of that group inherits the same access, so administrators avoid granting rights user by user. Members can sign in to the Mailbox Browser Interface and both add files to the mailbox and extract files from it, and they can do so through protocol adapters such as FTP and SFTP when the same rights are in place. The rights are not limited to a single action: it is not true that members can only view, only add or only extract. Within Sterling File Gateway, similar permissions are granted automatically to partner users for the mailboxes created for their routing channels, and View and Execute rights on intermediate mailboxes allow traversal of the mailbox tree. Using groups also simplifies auditing and offboarding, because removing a user from the group immediately removes the mailbox access. Statement D matches the documented behaviour of group assignment.
What must an Administrator do to raise the file-download size limit for myFileGateway 2.0?
Options:
Add property overrides to the customer_overrides.properties file.
Modify the limits set in the sandbox.cfg file.
Host myFileGateway 2.0 on an HTTP server adapter.
Increase the memory allocated to the Liberty server where the APIs are hosted.
Answer:
DExplanation:
myFileGateway 2.0 is a modern web application that talks to the Sterling B2B Integrator and Sterling File Gateway REST APIs, and those APIs are hosted on a WebSphere Liberty server. When a partner downloads a file, the Liberty server handles the transfer, and the largest file that can be downloaded is limited by the RAM of the computer and the heap size of the JVM running that server. Large downloads that fail are therefore a capacity problem on the Liberty server and not a product limit set in a property. IBM's documented workaround is to increase the RAM of the machine and then raise the JVM heap by editing the jvm.options file of the Liberty server, using -Xmx for the maximum heap and -Xms for the minimum. The server must be restarted for the change to take effect, and the change should be tested in a non-production environment first, because it can affect uploads and other clients. Adding overrides to customer_overrides.properties or changing sandbox.cfg does not alter Liberty's memory, and hosting the application on an HTTP server adapter only determines how it is exposed, not how much data the API server can buffer.
In a clustered environment with multiple JVMs running IBM Sterling B2B Integrator, how is the total number of database connections related to the number of connection pools?
Options:
The total number of connections is the same as the number of connection pools.
Each connection pool has a separate database connection regardless of the number of JVMs.
The total number of connections is independent of the number of connection pools.
The total number of connections is the sum of connections across all connection pools.
Answer:
DExplanation:
Sterling B2B Integrator uses internal connection pooling so that connections to the database server are reused instead of created for each request. Every JVM that runs part of the product, such as the application server nodes, the adapter container nodes and the operations server, creates its own connection pools. A pool holds a number of connections up to its configured maximum size, and when all pools are in use the system may request additional connections up to the buffer size. In a cluster, the database therefore sees the combined demand of every pool in every JVM. The total number of connections is the sum of the connections in all those pools, and it grows as nodes or pools are added. This is the reason capacity planning must multiply pool sizes by the number of JVMs and compare the result with the maximum number of sessions the database allows. If the total exceeds that limit, new connection attempts fail. A pool is not equal to a single connection, and a pool does not use one connection regardless of the number of JVMs. The total is also clearly dependent on the pools, which is why option D is correct.
Routine cleanup of old logs is important. Logs, particularly those that collect debug information, use substantial space. Which statement is true when the file-system space is completely full?
Options:
The Admin is forced to restart IBM Sterling File Gateway.
IBM Sterling File Gateway will continue running, but new logs cannot be written to.
IBM Sterling File Gateway will continue processing, but run slowly.
IBM Sterling File Gateway will stop functioning.
Answer:
DExplanation:
Sterling File Gateway runs on Sterling B2B Integrator, which writes continuously to the file system. Besides logs, it stores document payloads when the file system is the storage location, temporary files, mailbox and archive data, and JVM diagnostic output. When the file system is completely full, these writes fail, and processes cannot complete routing, delivery or even startup, so the application stops functioning instead of degrading gracefully. This is why log housekeeping is treated as a routine administrative task. New log files are created at midnight each day, and additional files are created if the maximum log size is exceeded during the day. Old logs are deleted automatically once the maximum number of log files is reached, which defaults to ten for the File Gateway log and can be changed with logService.filegatewaylogger.maxnumlogs in customer_overrides.properties. Debug logging should be turned on only while troubleshooting, because it increases log volume and affects performance. Monitoring free space, limiting retained log files and moving old archives are the preventive controls. A full file system is not a condition under which the product keeps processing, and it does not merely stop log creation, so statement D is correct.
After opening a Severity 3 - minor business impact case with IBM Support, a critical deadline must be met and the case is putting it at risk. Which process should be used to obtain increased attention for this support case?
Options:
Call an IBM Sales representative and ask them to reach out directly to IBM product support.
Continue to wait for a response while troubleshooting with teammates.
Use the IBM Support escalate case option and provide the circumstances for the request for escalation.
Email a company IT support and ask that they research the issue and provide the solution.
Answer:
CExplanation:
IBM Support separates the severity of a case, which describes technical impact, from the urgency of the customer's business need. A Severity 3 case can still be tied to a critical deadline, and IBM provides a formal case-escalation workflow for exactly that situation. From the open case, the customer selects the Escalate case option and supplies the escalation reason together with a description of the circumstances, including the deadline, the business consequence and what has been tried. The request is then reviewed by support management, which can adjust priority and assign additional resources. Severity 3 escalations are handled during the applicable business hours for the customer's support entitlement, so the request should be raised early and with complete details. Contacting a sales representative introduces an indirect route that does not enter the support queue and may delay action. Waiting while troubleshooting internally takes no step that changes the case's visibility, and the deadline remains at risk. Asking an internal IT team to research the problem does not engage the product support organisation that owns the case. Using the escalation option is the process that produces documented, accountable attention.
FTP supports data transfer in Active or Passive mode. Where is this mode configured?
Options:
FTP Client PUT service or FTP Client GET service
FTP Client Begin Session service
ftp.properties
FTP Client Adapter
Answer:
AExplanation:
FTP uses two connections: a control connection for commands and a separate data connection for file content and directory listings. Active and Passive modes differ in which side opens the data connection. In Active mode, the client sends a PORT command and the server connects back to the client, which can be blocked by firewalls. In Passive mode, the server announces an address and port, in a 227 response, and the client opens the connection. Because a data connection is created for each transfer command, the choice is made on the services that perform transfers, and the Sterling B2B Integrator FTP Client services allow the mode to be set as a parameter in the business process. The same parameter appears on the PUT and GET services, so option A is the best match. The Begin Session service opens the control session and defines the host, port and credentials, and it does not decide how each data connection is opened. The FTP Client adapter supplies perimeter server and port range settings, and ftp.properties holds general settings rather than the per-transfer mode.
Which two (2) resources are entities for which changes are recorded in the Admin Audit report? Choose two
Options:
Service/Adapter
Routing Rule
Keys
Certificate
Routing Channel
Answer:
A, BExplanation:
The Admin Audit report in Sterling B2B Integrator provides an audit trail of administrative changes. Entries are stored in the AUDIT_ADMIN table and can be searched from Operations > System > Audit Log by resource type, user and date range. A record shows who changed a resource, what the action was, and when it took place, so it supports accountability and compliance reviews. The resource types that can be selected include services and adapters, which are recorded as Service/Adapter, and routing rules, along with other protected items such as business processes, schedules, mailboxes, mailbox routing rules and user accounts. Changes to a service configuration or to a routing rule therefore appear in the report. Keys, certificates and routing channels are not offered as resource types for this report. Certificate and key management is handled through its own security screens, and Sterling File Gateway tracks its routing channel and partner activity through its own event and activity records. For this reason, administrators who need a complete change history should combine the Admin Audit report with system logs and external change management records. Service/Adapter and Routing Rule are the correct pair.
Which configuration file contains the document-encryption settings, including the system certificate in use (CERT_NAME=doccrypto2)?
Options:
propertyEncryption.properties
sandbox.cfg
security.properties
jdbc.properties
Answer:
CExplanation:
Document encryption adds a layer of protection for payloads stored in the database or on the file system. It relies on a system certificate, and the product supplies a predefined certificate named doccrypto for this purpose. The encryption behaviour is defined in the security properties, where the ENC_DECR_DOCS setting controls whether documents are encrypted in the file system, the database or both, and the CERT_NAME setting names the system certificate that is used. If an organisation creates its own document encryption certificate, such as doccrypto2, the CERT_NAME value must reference it. Following IBM's practice for property changes, the edit is made through customer_overrides.properties using the security. prefix, so that the change survives upgrades, and the system is restarted for it to take effect. The shipped definitions belong to security.properties, which makes it the correct file for this question. propertyEncryption.properties concerns the encryption of sensitive values stored in property files, such as passwords. sandbox.cfg holds installation and environment settings such as ports and JVM options. jdbc.properties defines database connection pools. None of them manages document encryption.
What type of information can be determined from the ARCHIVE_INFO table?
Options:
Information about failed IBM Sterling File Gateway transfers
If data is stuck with a 10 year lifespan
Business process (BP) or workflow execution steps
Communication sessions created in IBM Sterling B2B Integrator for different protocols
Answer:
BExplanation:
ARCHIVE_INFO holds lifespan information for all business processes and document storage in the system. The archive and purge services read it to decide when data is eligible to be archived and when it can be purged; for example, the purge service scans the table in batches. Administrators therefore query it to find workflows and documents whose purge date is unusually far in the future. A well-known case is data with a ten-year lifespan. Messages placed in a mailbox are given a default lifespan of ten years, and the associated business process and documents inherit that lifespan. Backup can archive the data, but the purge service will not remove it until the date is reached. Running the index business process resets the lifespan to the value configured in Archive Manager, and scheduling the mailbox delete service prevents the buildup. Failed File Gateway transfers are tracked in File Gateway activity and visibility data, workflow execution steps are stored in the workflow context tables, and communication sessions are held in session tables. None of those are described by ARCHIVE_INFO, so option B is correct.
What ID length does Native PGP support?
Options:
16-bit
32-bit
8-bit
64-bit
Answer:
AExplanation:
Native PGP, introduced in IBM Sterling B2B Integrator 6.1, performs PGP encryption, decryption, signing and verification inside the product and manages keys through the PGP Key Management dashboard and REST APIs. IBM's migration guidance states that when partner public keys are checked in, their Key IDs are stored as 16-bit IDs. Existing Sterling File Gateway trading partner profiles and PGP business processes that were built for external PGP often hold the shorter 8-bit key ID. IBM therefore recommends replacing those values with the 16-bit key ID, which is visible under Trading Partner > PGP Public Key in the dashboard. For example, the public_user value in the PGPPackageService business process should be updated, and consumer partners should be configured with the last 16 digits of the key fingerprint. In IBM's terminology the 16-bit label refers to the long key identifier of sixteen hexadecimal characters, as opposed to the short eight-character form. An 8-bit ID is the legacy format that must be migrated, and the 32-bit and 64-bit options are not the lengths documented for Native PGP in this context.
Which report identifies when a resource was modified and who made the modification in IBM Sterling B2B Integrator?
Options:
Admin Audit Report
System Health Report
Resource Change Log
User Activity Report
Answer:
AExplanation:
Sterling B2B Integrator records the creation, modification and deletion of administrative resources in the AUDIT_ADMIN table. Each entry holds the date and time of the operation, the resource name and type, the action performed and the user ID of the person who performed it. The table also captures when a user obtains or releases a lock on a resource through the Lock Manager. This information is presented through the Admin Audit report, which is run from Operations > Reports by selecting the Admin Audit type. Two report sources are provided: AdminAuditByObjectType, which groups changes by resource type, and AdminAuditByPrincipal, which groups them by user ID. Both show when something changed and who changed it, so they support change tracking, accountability and compliance reviews. The System Health Report describes the condition of the platform and does not record who modified a resource. Resource Change Log and User Activity Report are not the product's report names for this purpose. Because audit data is stored in a database table, it is also subject to the archive and purge settings that govern how long audit records remain available.
Which native service is available for both encryption/decryption and signing/verification?
Options:
xmIDSig
ebXMLDSig
xmlEncryptor
PGP
Answer:
DExplanation:
Sterling B2B Integrator offers several security-related services, and they differ in how much of the protection process they cover. PGP, which implements the OpenPGP standard, supports the complete set of operations. A document can be encrypted with the recipient's public key and decrypted with the matching private key, which gives confidentiality, and it can be signed with the sender's private key and verified with the sender's public key, which gives integrity and authentication. The same package can be configured for both in one step, so sending a file that is signed and encrypted requires only one service. In Sterling File Gateway, PGP processing is commonly performed with the built-in PGP service or through the Command Line 2 adapter with an external PGP implementation, and an adapter group can be used to balance high volumes. By contrast, the XML Digital Signature services, shown here as xmIDSig and ebXMLDSig, are designed only for signing and verifying XML content, and the XML Encryptor service is concerned with encryption and decryption of XML elements. None of those three provides both families of operations, so PGP is the correct choice.
Which UI is used to monitor resource utilization?
Options:
QueueWatch
MB Interface
SFG Dashboard
B2B Dashboard
Answer:
AExplanation:
QueueWatch, also called Queue Watcher, is the web interface that Sterling B2B Integrator provides for watching how system resources are being used by the workflow engine. It is available at the /queueWatcher address on the application's port and shows each business process queue, the number of threads in use, the depth of the queue and the processing backlog, and it lets an administrator reset queue parameters temporarily. IBM's system maintenance checklist recommends reviewing it daily to see whether there is a spike in load or a backlog building. Because it exposes thread and queue consumption, it is the first place to look when throughput declines and the team must decide whether to tune thread limits or move work between queues. The MB Interface is the mailbox browser used to view and manage mailbox contents, and it is not a resource monitor. The B2B Dashboard is the main administrative console for configuration, business process monitoring and reports, and Sterling File Gateway has its own operations interface for tracking routes. Neither of those provides the live queue and thread view that QueueWatch gives, so option A is the correct interface.
Which statement correctly describes services and adapters in IBM Sterling B2B Integrator?
Options:
There are only three Service Types.
Services provide core functionalities, while adapters enable communication with external systems.
Services and adapters are the same thing, just with different names.
Services are deprecated in IBM Sterling B2B Integrator.
Answer:
BExplanation:
In Sterling B2B Integrator, a service is a configurable component that a business process calls to perform a specific activity, such as translating data, handling documents, working with mailboxes, or running logic. An adapter is a specialised kind of service whose job is to connect the platform to external systems, applications and trading partners through protocols such as FTP, SFTP, HTTP, JDBC or MQ. Adapters are configured as service instances and are then used by services that act on their behalf; for example, an FTP Client adapter is used by the FTP Client Begin Session, GET and PUT services. Services therefore supply the core processing functions, while adapters provide the communication path. They are related, but they are not identical, so statement C is wrong. The product offers many more than three service types, including system, communication, translation and security services, so statement A is wrong. Services remain the basic building blocks of business process models and are not deprecated, although individual older services and adapters are retired and replaced over time. Statement B correctly distinguishes the two concepts and matches how administrators plan configuration and troubleshooting.
How can an administrator view the processing details for a failed file delivery?
Options:
Search active connections for the protocol in the Advanced Search - Communication Sessions screen.
Select the file and examine the workflow links in the Delivery events.
Search for the filename in the Data Flow Search screen and examine the appropriate data flow.
Examine the New Failures in the Activity Snapshot, selecting the file, and examine the Arrived File events.
Answer:
DExplanation:
Sterling File Gateway records every stage of a file's journey as events, and the interface is organised so that an operator can move from a summary to the details. The Activity Snapshot, available to Operators, shows counts of recent activity and highlights new failures, meaning payloads whose routing or delivery did not complete. Selecting the failure takes the administrator to the list of affected files, and choosing a file opens its detail view, which shows the Arrived File record with its events, the routing and delivery steps that followed, and the error code and message that explain what went wrong. From there, links to the business process and workflow can be followed to see the exact step that failed, which supports a decision to redeliver the file or correct the configuration. Searching for active connections in the communication sessions screen is useful for protocol connectivity problems, but it does not present the status of a specific file. The Data Flow Search is a Sterling B2B Integrator tool that is not the starting point in File Gateway, and the delivery events are reached through the file record. Starting from New Failures is the efficient route.
What is the documented sequence for updating the appearance of IBM Sterling B2B Integrator? (Place the four steps in the correct order.)
Options:
Restart IBM Sterling B2B Integrator
Refresh browser cache
Run deployer.sh / deployer.cmd
Edit skins.properties_style_ext
Restart IBM Sterling B2B Integrator
Refresh browser cache
Run deployer.sh / deployer.cmd
Answer:
A, B, C, DExplanation:
IBM documents a fixed procedure for changing the look of the Sterling B2B Integrator interface, and the order matters because each step depends on the previous one. First, the administrator edits skins.properties_style_ext, the extension file that holds site-specific style values, leaving the shipped skins.properties file untouched so that the customisation survives upgrades. Second, the deployer script, deployer.sh on UNIX and Linux or deployer.cmd on Windows, is run so the web application resources are rebuilt to include the changed style settings. Editing the file alone has no effect until it has been deployed. Third, Sterling B2B Integrator is restarted so that the deployed application loads the new configuration. Finally, users clear or refresh their browser cache, since browsers retain style sheets and images and would otherwise keep showing the previous appearance until the cached copies expire. The sequence is therefore edit, deploy, restart and refresh, which corresponds to D, C, A and B. Following it in this order avoids the common situation in which a change appears to be ignored because it was never deployed or was hidden by cached content.