Db2 vs. Formstack Forms

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

Formstack makes it easy to create a variety of forms. I have used it for event interest and registrations, email list sign-ups, and surveys. I have found it easy to customize, and easy to export data for import into other systems (e.g., CRM).

Incentivized

• 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

• Allows for unique situations. As a school, we don't have the luxury of being cookie cutter. Neither do our forms.
• Support. If we don't know how to do it, their support team has been very helpful and actually attempts to understand the issue on hand.
• User friendliness. In our field we have a phrase: "what if you get hit by a bus?" With Formstack, you can "get hit by the bus" and someone else can jump in and still keep things running (this is used as a phrase for illness, not termination).

Incentivized

• 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

• Setting up our multi-step form took some getting used to. Some of the branching logic configuration wasn't as intuitive as would be ideal.
• Since we were pushing data directly into Hubspot, I found it cumbersome to deal with data storage limits within Formstack. I would get frequent notices that new responses were not being stored in Formstack and that I needed to upgrade or delete data. I got tired of that.
• More/easier support for custom fonts would have been a huge plus. We were able to customize the form's appearance, but had to make some concessions in that regard.

Incentivized

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

Our user base has come to rely on Formstack to get forms done. The Formstack tools make it easy to start from scratch or copy an existing form to "quick start" a new, similar form. The price is right and frees up IT staff to do more transformative work.

Incentivized

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

It's easy to learn how to use, generally easy for clients to use, and overall I've never had an overwhelmingly negative experience with it. While there are a few tweaks that could make it really shine, Formstack Forms serves almost all our needs and we're super happy with it.

Incentivized

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

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

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

The agents in the original group, especially the ones in cahoots with the developers, are really solid and know what they're talking about--I'm looking at you, Collin. The 'Tier 1' support agents that typically reply to the tickets are really spotty. If you have an overly technical question, i.e. bugfix, or describe a feature from a few years back that randomly disappeared, these agents typically will give you what feels like a generic reply and not know what you're talking about.

Incentivized

the material was very clear and all subjects have been handled

Incentivized

db2 work well with the application, also the replication tool can keep it up

We implemented on one of the earlier versions. Through continuous engineering improvements, the interface keeps getting easier and more intuitive. Therefore, later implementations keep getting easier and better.

Incentivized

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

Drupal is a much more customizable platform, however you must have someone build the forms first and then you can work with them if you do not have the programming knowledge. If you have any changes to make, it can sometimes be both a time consuming and difficult process. Formstack is much more efficient if you do not have an in house programmer.

Incentivized

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

• 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

• Positive - ability to analyze submission trends - e.g. when a marketing email is sent, looking at increased form viewing and submissions in relation to the sending of the campaign.
• Immediate response - those that submit forms receive immediate response that their form has been submitted.

Incentivized