Latest Articles

Secure DevOps | September 24, 2020
Empower Your Developers and Users to Overcome Application Security Vulnerabilities
By reading & sharing this blog, you'll learn how to manage security risk in your applications more effectively, whether you're a user or app developer.
Data Management | September 24, 2020
The onunload and onload utilities
The onunload and onload utilities The onunload and onload utilities provide the fastest way to move data between computers that use the same database server on the same platform. For example, your site purchases a more powerful UNIX computer to allow faster access for users. You need to transfer existing databases to the new database server on the new computer. Use onunload to unload data from the first database server and then use onload to load the data into the second database server. Both database servers must have the same version number, or they must have compatible version numbers. You can move an entire database or selected tables only, but you cannot modify the database schema. The onunload utility can unload data more quickly than either dbexport or the UNLOAD statement because onunload copies the data in binary format and in page-sized units. The onload utility takes a tape or a file that the onunload utility creates and re-creates the database or the table. The onunload and onload utilities are faster than dbimport, dbload, or LOAD but are much less flexible and do not let you modify the database schema or move from one operating system or database server version to another. You can use only onunload and onload if your answer to each of the following questions is yes. If your answer is no, you cannot use onunload and onload. Is the target database server on the same hardware platform? Do you want to move to another database server of the same version? Do you want to keep the existing database schema without modifying it? Do you want to move an entire database or an entire table? Are the page images compatible? Are the numeric representations the same? When you can’t use the onunload and onload utilities Because the...
Data Management | September 24, 2020
HCL OneDB Power of duplication and High Availability
Abstract : Some businesses assume that a robust backup schedule is enough to keep their business running in the event of a disaster. These same organizations often believe that data replication systems are too complex, expensive or simply beyond their requirements. Fortunately, all three of these beliefs are wrong – here are top 5 reasons why every business needs a data replication solution: 1. Maximizing Systems Availability 2. Reduced Time to Recovery 3. Lower Costs in the Event of Outage or Disaster 4. Fully Accurate Data Copies 5. Improved Data Protection HCL OneDB has a full suite of technologies to provide uninterrupted and continuous services to minimize downtime and maintenance. The data duplication and high availability capability can reduce or eliminate costly Downtime. These capabilities enable faster, easier, and reliable distribution and high availability of data, enabling improved data access and use throughout the enterprise.
Data Management | September 24, 2020
Save your Money using Data Compression
Abstract : Abstract: Data compression is the processes that you can use to reduce the amount of disk space that is used by data in rows, simple large objects in dbspaces, and index keys using Compressing, Repacking, Shrinking & Defragmenting. We can save up to 90% of row storage space. Compressing data, simple large objects, or indexes and returning free space have the following benefits: 1. Significant savings in disk storage space 2. Reduced disk usage for compressed fragments 3. Significant saving of logical log usage, which saves more space and can prevent bottlenecks for high-throughput OLTP after the compression operation is completed. 4. Fewer page reads because more rows can fit on a page 5. Smaller buffer pools because more data fits in the same size pool 6. Reduced I/O activity: 7. More compressed rows than uncompressed rows fit on a page 8. Log records for insert, update, and delete operations of compressed rows are smaller 9. Ability to compress older fragments of time-fragmented data that are not often accessed, while leaving more recent data that is frequently accessed in uncompressed form 10. Ability to free space no longer required for a table 11. Faster backup and restore  
Data Management | September 24, 2020
Configure ONBAR backup and restore in just 2 Steps
HCL OneDB provides two utilities for backing up and restoring database server data. Both utilities backup and restore storage spaces and logical logs. However, they support different features, and it is important to know the differences. These topics explain basic backup and restore concepts for HCL OneDB database servers and compares the ON-Bar utility. ON-Bar backs up and restores storage spaces (dbspaces) and logical file, by using a storage manager. Onbar Description: Backup and restores storage spaces (dbspaces) and logical log files, using a storage manager to track backups and storage media Includes: Parallel backup and restore System level and dbspace level backup and restore Support for incremental backups Manual or automatic backup of logical logs Point-in-time recovery for an instance Provides an open interface for communication with storage manager (XBSA) Third party storage managers may provide support for sophisticated tape stacker and jukebox devices. ON-Bar components include a command-line utility, catalog tables, an activity log, and an emergency boot file. You use ON-Bar with a storage manager and the XBSA shared library for the storage manager. The following figure shows the ON-Bar and database server components: The storage spaces (dbspaces, blobspaces, and sbspaces) and logical logs from the database server The sysutils database, which includes ON-Bar catalog tables The onbar and the onbar-d command-line utilities The XBSA shared library for the storage manager on your system The storage media for storing backups The ON-Bar activity log The ON-Bar emergency boot file ON-Bar communicates with both the database server and the storage manager. You use the onbar command to start a backup or restore operation. By default, ON-Bar backs up and restores storage spaces in parallel. ON-Bar always processes log files serially. For a backup session, ON-Bar requests the contents of storage spaces and logical logs from the database server...
Data Management | September 24, 2020
HCL OneDB – ALL THE KNOWLEDGE IS IN THE CONNECTIONS
OneDB is a flexible database server that manages traditional relational, object-relational and dimensional databases. OneDB database server runs on Unix, Linux, Mac OS X and Windows operation systems. OneDB Explore is a modernized tool for monitoring and managing your OneDB database servers. It imparts performance management capabilities, examines how key performance metrics are changing with time, and tracks how efficiently OneDB is working even when you are away from your screen. It notifies about issues arising on one of your OneDB database server instances via email, Twilio or PagerDuty. OneDB Explore is a focal point for graphical monitoring, alerting and administration of your OneDB database servers. After logging in to OneDB Explore, you will be directed to group dashboard for the root group. This dashboard contains zero servers and zero groups. Adding Servers and Group Click the Add Server button to add connection information for your OneDB database server instances. Provide monitoring and admin credentials. The monitoring credentials are used by OneDB Explore server and agent to gather data from OneDB database server instance. The admin credentials are used for administration action performed on the database server, for example create a dbspace, edit an onconfig parameter, or deploy an agent. Click the Add Group button to create group of servers that makes it easier to monitor and manage multiple servers. Monitoring OneDB Explore has built in, customizable sensors for monitoring database servers. The agent is facilitated to monitor database server status automatically. Whenever a change is detected, it immediately notifies as a “status” update. The sensors to be monitored in the UI are defined by the user. For gathering monitoring data, agent runs the sensor metrics classes by – Running queries against the sysmaster database Running onstat commands Running OS command for host machine monitoring Monitoring data is stored into...

Upcoming Event

On-Demand Video and How It Can Be the Key to Improving Digital Experiences
October 27, 2020,
REGISTER
a/icon/common/search Created with Sketch.