TrustRadius: an HG Insights company

CA Scheduler Job Management vs. Db2 vs. Oracle Autonomous Transaction Processing

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    CA Scheduler Job Management

    Score5 out of 10
    N/ACA Scheduler Job Management is IT workload automation software from CA Technologies.N/A

    Db2

    Score8.6 out of 10
    N/ADB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.

    $0

    Oracle Autonomous Transaction Processing

    Score9 out of 10
    N/AOracle offers the Autonomous Transaction Processing, supporting database self-repair and maintenance with machine learning to eliminate human labor, human error, and manual tuning.

    $1.34

    OCPU Per Hour

    Pricing
    CA Scheduler Job ManagementDb2Oracle Autonomous Transaction Processing
    Editions & Modules
    No answers on this topic
    Db2 on Cloud Lite
    $0
    Db2 on Cloud Standard
    $99
    per month
    Db2 Warehouse on Cloud Flex One
    $898
    per month
    Db2 on Cloud Enterprise
    $946
    per month
    Db2 Warehouse on Cloud Flex for AWS
    2,957
    per month
    Db2 Warehouse on Cloud Flex
    $3,451
    per month
    Db2 Warehouse on Cloud Flex Performance
    13,651
    per month
    Db2 Warehouse on Cloud Flex Performance for AWS
    13,651
    per month
    Db2 Standard Edition
    Contact Sales
    Db2 Advanced Edition
    Contact Sales
    Transaction Processing
    $1.34
    OCPU Per Hour
    Exadata Storage
    $118.40
    Per Terabyte Per month
    Offerings
    Pricing Offerings
    CA Scheduler Job ManagementDb2Oracle Autonomous Transaction Processing
    Free Trial
    NoYesYes
    Free/Freemium Version
    NoYesYes
    Premium Consulting/Integration Services
    NoYesYes
    Entry-level Setup FeeNo setup feeOptionalOptional
    Additional Details———
    More Pricing Information
    Community Pulse
    CA Scheduler Job ManagementDb2Oracle Autonomous Transaction Processing
    Considered Multiple Products
    Broadcom
    No answer on this topic
    IBM
    No answer on this topic
    Oracle
    No answer on this topic
    Key User Insights
    Would buy again
    No answers on this topic
    96%
    Would buy again
    103 Answers
    No answers on this topic
    Delivers good value for the price
    No answers on this topic
    97%
    Delivers good value for the price
    95 Answers
    No answers on this topic
    Happy with the feature set
    No answers on this topic
    96%
    Happy with the feature set
    103 Answers
    No answers on this topic
    Lived up to sales and marketing promises
    No answers on this topic
    96%
    Lived up to sales and marketing promises
    66 Answers
    No answers on this topic
    Implementation went as expected
    No answers on this topic
    99%
    Implementation went as expected
    89 Answers
    No answers on this topic
    Features
    CA Scheduler Job ManagementDb2Oracle Autonomous Transaction Processing
    Workload Automation
    Comparison of Workload Automation features of CA Scheduler Job Management and Db2 and Oracle Autonomous Transaction Processing
    Feature
    CA Scheduler Job Management
    8.0
    1 Ratings
    3% below category average
    Db2
    -
    Ratings
    Oracle Autonomous Transaction Processing
    -
    Ratings
    Logging8.01 Ratings00 Ratings00 Ratings
    Analysis and visualization8.01 Ratings00 Ratings00 Ratings
    Best Alternatives
    CA Scheduler Job ManagementDb2Oracle Autonomous Transaction Processing
    Small Businesses
    No answers on this topic
    Amazon RDS
    Score8.1 out of 10
    MongoDB Atlas
    Score7.8 out of 10
    Medium-sized Companies
    Apache Airflow
    Score8.7 out of 10
    SingleStore
    Score8.2 out of 10
    Azure Database
    Score8.8 out of 10
    Enterprises
    Redwood RunMyJobs
    Score9.7 out of 10
    SAP IQ
    Score5.4 out of 10
    Google Cloud SQL
    Score8.7 out of 10
    All AlternativesView all alternativesView all alternativesView all alternatives
    User Ratings
    CA Scheduler Job ManagementDb2Oracle Autonomous Transaction Processing
    Likelihood to Recommend
    7.0
    (1 ratings)
    9.1
    (114 ratings)
    9.1
    (2 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    7.9
    (12 ratings)
    -
    (0 ratings)
    Usability
    -
    (0 ratings)
    8.4
    (9 ratings)
    7.3
    (1 ratings)
    Availability
    -
    (0 ratings)
    9.3
    (64 ratings)
    -
    (0 ratings)
    Performance
    -
    (0 ratings)
    9.1
    (12 ratings)
    -
    (0 ratings)
    Support Rating
    -
    (0 ratings)
    8.9
    (6 ratings)
    -
    (0 ratings)
    In-Person Training
    -
    (0 ratings)
    8.2
    (1 ratings)
    -
    (0 ratings)
    Implementation Rating
    -
    (0 ratings)
    5.6
    (3 ratings)
    -
    (0 ratings)
    Configurability
    -
    (0 ratings)
    9.1
    (2 ratings)
    -
    (0 ratings)
    Data Sharing and Collaboration
    -
    (0 ratings)
    8.0
    (1 ratings)
    -
    (0 ratings)
    Data Sources
    -
    (0 ratings)
    9.0
    (1 ratings)
    -
    (0 ratings)
    Ease of integration
    -
    (0 ratings)
    7.8
    (4 ratings)
    -
    (0 ratings)
    Product Scalability
    -
    (0 ratings)
    8.3
    (66 ratings)
    -
    (0 ratings)
    Vendor post-sale
    -
    (0 ratings)
    9.0
    (2 ratings)
    -
    (0 ratings)
    Vendor pre-sale
    -
    (0 ratings)
    9.0
    (2 ratings)
    -
    (0 ratings)
    User Testimonials
    CA Scheduler Job ManagementDb2Oracle Autonomous Transaction Processing
    Likelihood to Recommend
    Broadcom
    Job scheduling software for the IBM Mainframe is quite mature and most IBM Mainframe sites would already have one installed. It would appear to be very little reason to change from one scheduling package to another. If you were looking for a new scheduling package, CA Technologies is more likely to steer you towards their other product
    Incentivized
    Read full review
    IBM
    I have primarily used it as the basis for a SIS - but I have migrated more than a few systems from there database systems to DB2 (Filemaker, MySQL, etc.). DB2 does have a better structural approach, as opposed to Filemaker, which allows for more data consistency, but this can also lead to an inflexibility that can sometimes be counterintuitive when attempting to compensate for the flexibility of the work environment as Schools tend to have an all in one approach.
    Incentivized
    Read full review
    Oracle
    If your company's value is not increased by maintaining databases, you should use the ATP.
    Read full review
    Pros
    Broadcom
    • Good reporting on completed schedules and jobs including highest return code of jobs.
    • ISPF interface can cope with non-standard screen sizes.
    • Easy to use ISPF interface
    Incentivized
    Read full review
    IBM
    • While we query a large set of data, the results are generally available within a minute or so.
    • Always reliable - I have never experienced an application going down.
    • It is easy to write queries and find tables and columns.
    • We can log in smoothly without any headaches.
    Incentivized
    Read full review
    Oracle
    • Quick and simple to deploy (less than 5 steps to create a new instance)
    • No administrative tasks (backup, re-sizing) required
    Incentivized
    Read full review
    Cons
    Broadcom
    • Monitoring interface could make better use of screen colours
    Incentivized
    Read full review
    IBM
    • Learning curve for DB resources - Improvements to UI or native command line built-ins can help with increasing efficiencies for DB resources
    • Better resource utilization monitoring and recommendations
    • Continue to adopt support for modern frameworks and languages making it easier for organizations to see making Db2 the easy first choice
    Incentivized
    Read full review
    Oracle
    • Connectivity between ATP and Oracle Kuberentes Engine cluster seems to drop randomly
    • The ATP could come in an even smaller shape as the smallest shape is already quite big . But if must be more than always free, as that version does have connectivity limitations about 20 connections
    Read full review
    Likelihood to Renew
    Broadcom
    No answers on this topic
    IBM
    The DB2 database is a solid option for our school. We have been on this journey now for 3-4 years so we are still adapting to what it can do. We will renew our use of DB2 because we don’t see. Major need to change. Also, changing a main database in a school environment is a major project, so we’ll avoid that if possible.
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Usability
    Broadcom
    No answers on this topic
    IBM
    You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.
    Incentivized
    Read full review
    Oracle
    You get almost all the features of Oracle Database, including the ability to deploy APEX applications, without having to worry about system, storage or database configuration and maintenance, backups, etc. Also, you can start for free and move up adding resources as you need.
    Incentivized
    Read full review
    Reliability and Availability
    Broadcom
    No answers on this topic
    IBM
    I have never had DB2 go down unexpectedly. It just works solidly every day. When I look at the logs, sometimes DB2 has figured out there was a need to build an index. Instead of waiting for me to do it, the database automatically created the index for me. At my current company, we have had zero issues for the past 8 years. We have upgrade the server 3 times and upgraded the OS each time and the only thing we saw was that DB2 got better and faster. It is simply amazing.
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Performance
    Broadcom
    No answers on this topic
    IBM
    The performances are exceptional if you take care to maintain the database. It is a very powerful tool and at the same time very easy to use. In our installation, we expect a DB machine on the mainframe with access to the database through ODBC connectors directly from branch servers, with fabulous end users experience.
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Support Rating
    Broadcom
    No answers on this topic
    IBM
    Easily the best product support team. :) Whenever we have questions, they have answered those in a timely manner and we like how they go above and beyond to help.
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    In-Person Training
    Broadcom
    No answers on this topic
    IBM
    the material was very clear and all subjects have been handled
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Implementation Rating
    Broadcom
    No answers on this topic
    IBM
    db2 work well with the application, also the replication tool can keep it up
    Read full review
    Oracle
    No answers on this topic
    Alternatives Considered
    Broadcom
    All quite similar and as CA Scheduler had the smallest foot print across the agencies we support it is being decommmissioned
    Incentivized
    Read full review
    IBM
    DB2 was more scalable and easily configurable than other products we evaluated and short listed in terms of functionality and pricing. IBM also had a good demo on premise and provided us a sandbox experience to test out and play with the product and DB2 at that time came out better than other similar products.
    Incentivized
    Read full review
    Oracle
    Both Azure SQL Database and Oracle Autonomous Transaction Processing offer a powerful and robust database platform. The advantage of Autonomous Transaction Processing is the ability to host APEX applications for free and without any special/complicated deployment or configuration process. Having a rapid development environment embedded for free was the main advantage for choosing Oracle as my cloud database provider.
    Incentivized
    Read full review
    Scalability
    Broadcom
    No answers on this topic
    IBM
    By
    using DB2 only to support my IzPCA activities, my knowledge here
    is somewhat limited.

    Anyway,
    from what I was able to understand, DB2 is extremely scallable.

    Maybe the information below could serve as an example of scalability.
    Customer have an huge mainframe environment, 13x z15 CECs, around
    80 LPARs, and maybe more than 50 Sysplexes (I am not totally sure about this
    last figure...)

    Today
    we have 7 IzPCA
    databases, each one in a distinct Syplex.

    Plans
    are underway to have, at the end, an small LPAR, with only one DB2 sub-system,
    and with only one database, then transmit the data from a lot of other LPARs,
    and then process all the data in this only one database.



    The
    IzPCA collect process (read the data received, manipulate it, and insert rows
    in the tables) today is a huge process, demanding many elapsed
    hours, and lots of CPU.

    Almost
    100% of the tables are PBR type, insert jobs run in parallel, but in 4 of the 7
    database, it is a really a huge and long process.



    Combining
    the INSERTs loads from the 7 databases in only one will be impossible.......,,,,



    But,
    IzPCA recently introduced a new feature, called "Continuous
    Collector"
    .
    By
    using that feature, small amounts of data will be transmited to the central
    LPAR at every 5 minutes (or even less), processed immediately,in
    a short period of time, and with small use of CPU,
    instead of one or two transmissions by day, of very large amounts of data and
    the corresponding collect jobs occurring only once or twice a day, with long
    elapsed times, and huge comsumption of CPU



    I
    suspect the total CPU seconds consumed will be more or less the same in
    both cases, but in the new method it will occur in small bursts
    many times a day!!
    Incentivized
    Read full review
    Oracle
    No answers on this topic
    Return on Investment
    Broadcom
    • Being decommissioned due to software rationalisation.
    Incentivized
    Read full review
    IBM
    • Negative: Difficult and manual deployment
    • Negative: Missing assistants from common monitoring metrics
    • Positive: Stability
    • Positive: Performance
    • Positive: Resiliency and high availability (HADR)
    • Positive: Data Replication (Q-Rep)
    • Positive: Interaction with storage subsystems for backups (TSM, SVC)
    • Positive: Gigantic monitoring features in the form of table functions
    Incentivized
    Read full review
    Oracle
    • Approx 100 times faster spin up than manual setup of an Oracle DB
    • 3h annual maintenance for big version releases (18c to 19c) compared to est. 500h annual maintenance with manual database updates
    Read full review
    ScreenShots

    Db2 Screenshots

    Screenshot of Db2 - Data sharingScreenshot of Db2 - Machine LearningScreenshot of Db2 - Real time insights

    Oracle Autonomous Transaction Processing Screenshots

    Screenshot of Autonomous Transaction Processing Database takes automatic backupsScreenshot of Provisioning a new Autonomous Transaction Processing is simpleScreenshot of Autonomous Transaction Processing Database  ConsoleScreenshot of Auto scaling and manual scaling options of the database