# \#Adabas-Add-on-Products **URL:** https://techcommunity.softwareag.com/tag/adabas-add-on-products/87.md [Latest](https://techcommunity.softwareag.com/latest.md) · [Categories](https://techcommunity.softwareag.com/categories.md) · [Tags](https://techcommunity.softwareag.com/tags.md) --- ## [Is there a service function to "ping" defined data servers?](https://techcommunity.softwareag.com/t/is-there-a-service-function-to-ping-defined-data-servers/208180)
**Author:** [@ChristianHeld](https://techcommunity.softwareag.com/u/ChristianHeld)\ **Replies:** 2\ **Last updated:** [June 3, 2020, 8:20pm UTC](https://techcommunity.softwareag.com/t/is-there-a-service-function-to-ping-defined-data-servers/208180 "2020-06-03T20:20:14Z")
Hello I have a simple question. ACE offers a set of “service” functions which retrieve internal JDBC data. Examples: SELECT CNXCURRENTCONNECTIONS() ,CNXPEAKCONNECTIONS() ,CNXTOTALCONNECTIONS() ,CNXCURRENTSTATEMEN… --- ## [Can Encryption be put on the Data been retrieved from the Mainframe Adabas Database](https://techcommunity.softwareag.com/t/can-encryption-be-put-on-the-data-been-retrieved-from-the-mainframe-adabas-database/227258)
**Author:** [@anon55491631](https://techcommunity.softwareag.com/u/anon55491631)\ **Replies:** 1\ **Last updated:** [June 1, 2020, 3:22pm UTC](https://techcommunity.softwareag.com/t/can-encryption-be-put-on-the-data-been-retrieved-from-the-mainframe-adabas-database/227258 "2020-06-01T15:22:49Z")
We have a customer who want to access data from a Adabas Database on the Mainframe (z/os) through Entire Net-work to the Adabas SQL on LINUX and applications using an ODBC link. this is a bank and need to ensure the da… --- ## [Used of Super Descriptor to Optimize SQL Query](https://techcommunity.softwareag.com/t/used-of-super-descriptor-to-optimize-sql-query/101784)
**Author:** [@Min\_Chai](https://techcommunity.softwareag.com/u/Min_Chai)\ **Replies:** 5\ **Last updated:** [December 22, 2012, 4:20pm UTC](https://techcommunity.softwareag.com/t/used-of-super-descriptor-to-optimize-sql-query/101784 "2012-12-22T16:20:55Z")
We have an Adabas file that looks like this: REPORT name (a5) - a descriptor used-information - PE used-code (a1) used-date (n8 ) This file has a superdescriptor name-used-code-sp which consists of the fiel… --- ## [How to create a space alert in ADABAS files](https://techcommunity.softwareag.com/t/how-to-create-a-space-alert-in-adabas-files/204806)
**Author:** [@Fernando\_Zarazua\_Vilchis2](https://techcommunity.softwareag.com/u/Fernando_Zarazua_Vilchis2)\ **Replies:** 2\ **Last updated:** [August 9, 2019, 7:54am UTC](https://techcommunity.softwareag.com/t/how-to-create-a-space-alert-in-adabas-files/204806 "2019-08-09T07:54:45Z")
how to create a space alert in ADABAS files. I work at Mainframe Z/OS 2.1 and I need to receive alerts about files, processes, user etc. etc. Can any colleague help me? Thanks. --- ## [How to handle Role base access](https://techcommunity.softwareag.com/t/how-to-handle-role-base-access/204626)
**Author:** [@Suresh\_Thogari](https://techcommunity.softwareag.com/u/Suresh_Thogari)\ **Replies:** 1\ **Last updated:** [July 17, 2019, 4:13pm UTC](https://techcommunity.softwareag.com/t/how-to-handle-role-base-access/204626 "2019-07-17T16:13:55Z")
Hi, i would like to know how Software AG will going to handle Role based access. please suggest with any documentation. --- ## [CONNX SSL Encryption Impacting Behaviour of Update/Delete?](https://techcommunity.softwareag.com/t/connx-ssl-encryption-impacting-behaviour-of-update-delete/201565)
**Author:** [@Min\_Chai1](https://techcommunity.softwareag.com/u/Min_Chai1)\ **Replies:** 1\ **Last updated:** [July 15, 2019, 4:21am UTC](https://techcommunity.softwareag.com/t/connx-ssl-encryption-impacting-behaviour-of-update-delete/201565 "2019-07-15T04:21:36Z")
We have enabled SSL on both the CONNX JDBC Server and the CONNX Gateway via AT-TLS. Ever since we turned on CNXLISTENSSL = 1, our java programs which do massive update and delete seem to run significantly slower. 2.5x … --- ## [How do I start and rollback a transaction](https://techcommunity.softwareag.com/t/how-do-i-start-and-rollback-a-transaction/203795)
**Author:** [@Michael\_Trexel](https://techcommunity.softwareag.com/u/Michael_Trexel)\ **Replies:** 1\ **Last updated:** [July 15, 2019, 4:19am UTC](https://techcommunity.softwareag.com/t/how-do-i-start-and-rollback-a-transaction/203795 "2019-07-15T04:19:47Z")
I am using SQL Server 2016 with a linked server to ADABAS using the CONNX 11 SP3 driver. I would like to start a transaction, run one to many transactions, and then commit them at the end of the process, but if any of t… --- ## [How to import the data from ADABAS to AWS Redshift using SQL Gateway/CONNX Driver?](https://techcommunity.softwareag.com/t/how-to-import-the-data-from-adabas-to-aws-redshift-using-sql-gateway-connx-driver/204333)
**Author:** [@Satyender\_Murahari1](https://techcommunity.softwareag.com/u/Satyender_Murahari1)\ **Replies:** 1\ **Last updated:** [July 15, 2019, 4:01am UTC](https://techcommunity.softwareag.com/t/how-to-import-the-data-from-adabas-to-aws-redshift-using-sql-gateway-connx-driver/204333 "2019-07-15T04:01:59Z")
Hi All, Could you please help me in… how to import the data from ADABAS to AWS Redshift using SQL Gateway/CONNX Driver? Thanks, Satyender Murahari satyender.murahari@dds.ca.gov +1 916 817 7427 --- ## [How to import the data from ADABAS to AWS Redshift using SQL Gateway/CONNX Driver?](https://techcommunity.softwareag.com/t/how-to-import-the-data-from-adabas-to-aws-redshift-using-sql-gateway-connx-driver/204331)
**Author:** [@Satyender\_Murahari1](https://techcommunity.softwareag.com/u/Satyender_Murahari1)\ **Replies:** 2\ **Last updated:** [July 9, 2019, 9:56am UTC](https://techcommunity.softwareag.com/t/how-to-import-the-data-from-adabas-to-aws-redshift-using-sql-gateway-connx-driver/204331 "2019-07-09T09:56:14Z")
Hello, We have a requirement to import the data from ADABAS Dataabase to AWS Redshift. How to import the data from ADABAS to Redshift using SQL Gateway/CONNX Driver? Could you please let me know the process? Thanks, … --- ## [Adabas SQLGateway & Hibernate](https://techcommunity.softwareag.com/t/adabas-sqlgateway-hibernate/85147)
**Author:** [@tamino\_man](https://techcommunity.softwareag.com/u/tamino_man)\ **Replies:** 7\ **Last updated:** [May 22, 2019, 2:21pm UTC](https://techcommunity.softwareag.com/t/adabas-sqlgateway-hibernate/85147 "2019-05-22T14:21:18Z")
Hi. I want to use Adabas SQL Gateway(CONNX) with Hibernate(version 3.1). But Hibernate seem to is not support Adabas SQL Gateway. (Dialect class for Adabas SQL Gateway is not exist.) I must add a new Dialect class? o… --- ## [Data Archival APIs](https://techcommunity.softwareag.com/t/data-archival-apis/203286)
**Author:** [@Brian\_Johnson1](https://techcommunity.softwareag.com/u/Brian_Johnson1)\ **Replies:** 10\ **Last updated:** [April 15, 2019, 12:24pm UTC](https://techcommunity.softwareag.com/t/data-archival-apis/203286 "2019-04-15T12:24:27Z")
I was looking at the API functionality in the Data Archive for ADABAS product in order to make it easier to report on how many records were “archived” in a given month. Currently, I go to the console under System Manage… --- ## [Startup & Shutdown process relating to REPTOR](https://techcommunity.softwareag.com/t/startup-shutdown-process-relating-to-reptor/203087)
**Author:** [@Boualay\_Bounma2](https://techcommunity.softwareag.com/u/Boualay_Bounma2)\ **Replies:** 1\ **Last updated:** [March 27, 2019, 10:40am UTC](https://techcommunity.softwareag.com/t/startup-shutdown-process-relating-to-reptor/203087 "2019-03-27T10:40:31Z")
In regard to Event Replicator for ADABAS, is there a startup process for REPTOR, ENTIREX, PSTORE, Event Replicator Online System, and ADABAS databases to be replicated? In other word, for startup, what order should thes… --- ## [SQL Gateway / how to do it / List of values, determine MIN, MAX](https://techcommunity.softwareag.com/t/sql-gateway-how-to-do-it-list-of-values-determine-min-max/202688)
**Author:** [@ChristianHeld](https://techcommunity.softwareag.com/u/ChristianHeld)\ **Replies:** 5\ **Last updated:** [March 25, 2019, 5:41pm UTC](https://techcommunity.softwareag.com/t/sql-gateway-how-to-do-it-list-of-values-determine-min-max/202688 "2019-03-25T17:41:56Z")
Hi I need a hint, maybe someone can give an advice I have a SELECT Statement, the structure is: SELECT xyz FROM table where col in ( ). The is specified by the end user. What I need is the MAX( ) and MIN( ) Bas… --- ## [Mainframe ADABAS/Natural riding into the sunset](https://techcommunity.softwareag.com/t/mainframe-adabas-natural-riding-into-the-sunset/203013)
**Author:** [@Michael\_Echanove](https://techcommunity.softwareag.com/u/Michael_Echanove)\ **Replies:** 3\ **Last updated:** [March 4, 2019, 6:45am UTC](https://techcommunity.softwareag.com/t/mainframe-adabas-natural-riding-into-the-sunset/203013 "2019-03-04T06:45:43Z")
After 4+ decades of production work our IBM mainframe environment is scheduled to be replaced in the summer of 2020. I have been asked to provide input as to what the best options might be to still have our ADABAS data … --- ## [Adabas Manager Open SYstems](https://techcommunity.softwareag.com/t/adabas-manager-open-systems/203011)
**Author:** [@MikeWaldron](https://techcommunity.softwareag.com/u/MikeWaldron)\ **Replies:** 0\ **Last updated:** [February 28, 2019, 8:39pm UTC](https://techcommunity.softwareag.com/t/adabas-manager-open-systems/203011 "2019-02-28T20:39:04Z")
We have Adabas Manger working just fine on Red Hat Linux using MobaXterm X11. But when I go through a browser, it doesn’t see any databases. I have put ADADATADIR=/opt/softwareag/Adabas in the start and amn.sh script … --- ## [\[08001\]\[unixODBC\]You are not licensed for any databases](https://techcommunity.softwareag.com/t/08001-unixodbc-you-are-not-licensed-for-any-databases/100871)
**Author:** [@hcontreras](https://techcommunity.softwareag.com/u/hcontreras)\ **Replies:** 3\ **Last updated:** [December 6, 2018, 9:14am UTC](https://techcommunity.softwareag.com/t/08001-unixodbc-you-are-not-licensed-for-any-databases/100871 "2018-12-06T09:14:21Z")
What its mean: \[08001\]\[unixODBC\]You are not licensed for any databases. in my connxreg64.db. CONNX.LICENSESERVER : xxx.xxx.xxx and CONNX.LICENSEPORT: 7501. In windows 7 (64 bits) work perfect… what its problem?. my … --- ## [Last record of access to the file.](https://techcommunity.softwareag.com/t/last-record-of-access-to-the-file/201541)
**Author:** [@Fernando\_Zarazua\_Vilchis1](https://techcommunity.softwareag.com/u/Fernando_Zarazua_Vilchis1)\ **Replies:** 1\ **Last updated:** [November 5, 2018, 6:54am UTC](https://techcommunity.softwareag.com/t/last-record-of-access-to-the-file/201541 "2018-11-05T06:54:56Z")
I have the task of Deleting Adabas Files, how can I know when was the last access to the Archvio and which fields are not used, is there a method? For environment Mainframe Z/OS. It can be done with sysaos or with sys… --- ## [Accessing ADABAS from JAva](https://techcommunity.softwareag.com/t/accessing-adabas-from-java/201294)
**Author:** [@VINOTH\_SIVAKUMAR](https://techcommunity.softwareag.com/u/VINOTH_SIVAKUMAR)\ **Replies:** 2\ **Last updated:** [October 18, 2018, 2:49pm UTC](https://techcommunity.softwareag.com/t/accessing-adabas-from-java/201294 "2018-10-18T14:49:04Z")
Hello I am working legacy migration project which involves migrating business logic written in COBOL to Java. The existing COBOL program interacts with ADABAS thru C program. Now we are trying to bring that section of c… --- ## [Adabas SQL Gateway Community Resources](https://techcommunity.softwareag.com/t/adabas-sql-gateway-community-resources/200786)
**Author:** [@Community-admin](https://techcommunity.softwareag.com/u/Community-admin)\ **Replies:** 0\ **Last updated:** [August 30, 2018, 9:18am UTC](https://techcommunity.softwareag.com/t/adabas-sql-gateway-community-resources/200786 "2018-08-30T09:18:14Z")
Useful resources: Adabas SQL Gateway technical articles Adabas SQL Gateway tips, tricks & code Adabas SQL Gateway videos --- ## [Adabas SOA Gateway Community Resources](https://techcommunity.softwareag.com/t/adabas-soa-gateway-community-resources/200715)
**Author:** [@Community-admin](https://techcommunity.softwareag.com/u/Community-admin)\ **Replies:** 0\ **Last updated:** [August 29, 2018, 2:26pm UTC](https://techcommunity.softwareag.com/t/adabas-soa-gateway-community-resources/200715 "2018-08-29T14:26:42Z")
Useful resources: Adabas SOA Gateway technical articles Adabas SOA Gateway tips, tricks & code Adabas SOA Gateway videos --- ## [Documents/Information on ADABAS in Mainframe](https://techcommunity.softwareag.com/t/documents-information-on-adabas-in-mainframe/200308)
**Author:** [@Khalinder\_Attar](https://techcommunity.softwareag.com/u/Khalinder_Attar)\ **Replies:** 2\ **Last updated:** [August 1, 2018, 4:44pm UTC](https://techcommunity.softwareag.com/t/documents-information-on-adabas-in-mainframe/200308 "2018-08-01T16:44:09Z")
Hi All, I am going to work as ADABAS DBA. Could you please help me by providing the documents or information related to ADABAS DBA. I am having 18 years of experience on Mainframe technologies, worked as DB2 DBA, appli… --- ## [Data Archival selection criteria: less than January 1 of x years ago](https://techcommunity.softwareag.com/t/data-archival-selection-criteria-less-than-january-1-of-x-years-ago/200294)
**Author:** [@Brian\_Johnson1](https://techcommunity.softwareag.com/u/Brian_Johnson1)\ **Replies:** 2\ **Last updated:** [July 31, 2018, 5:13pm UTC](https://techcommunity.softwareag.com/t/data-archival-selection-criteria-less-than-january-1-of-x-years-ago/200294 "2018-07-31T17:13:04Z")
One enhancement had been made for a use case we had at the time where if we were running an archival extraction, and we wanted to archive 3 years ago or more if it was before the 1st of the month, we could specify this (… --- ## [Regarding ISN Buffer limit (Adabas Vista Error : +0249).](https://techcommunity.softwareag.com/t/regarding-isn-buffer-limit-adabas-vista-error-0249/200167)
**Author:** [@Megha\_CF](https://techcommunity.softwareag.com/u/Megha_CF)\ **Replies:** 4\ **Last updated:** [July 24, 2018, 5:12pm UTC](https://techcommunity.softwareag.com/t/regarding-isn-buffer-limit-adabas-vista-error-0249/200167 "2018-07-24T17:12:57Z")
Hi All, I have loaded one record in adabas file which has ISN value greater than 2,147,483,647. I am receiving adabas response +0249 (Adabas Vista Error). 02 ADA-CTRL-ADDITIONS-2 X(4) .. 4400 000F ISN length is S9(… --- ## [Adabas Vista 8.2 project watch](https://techcommunity.softwareag.com/t/adabas-vista-8-2-project-watch/80101)
**Author:** [@Mike\_Meehan](https://techcommunity.softwareag.com/u/Mike_Meehan)\ **Replies:** 1\ **Last updated:** [July 19, 2018, 5:54pm UTC](https://techcommunity.softwareag.com/t/adabas-vista-8-2-project-watch/80101 "2018-07-19T17:54:00Z")
Hi, I am responsible for Adabas Vista in Software AG R&D. I thought it would be interesting to tell you the things we are working on in the next wave. Here’s a few words on the main things… Allow partitioned files to… --- ## [Adabas Manager Communication Client is not running](https://techcommunity.softwareag.com/t/adabas-manager-communication-client-is-not-running/192646)
**Author:** [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\ **Replies:** 3\ **Last updated:** [May 17, 2018, 12:19pm UTC](https://techcommunity.softwareag.com/t/adabas-manager-communication-client-is-not-running/192646 "2018-05-17T12:19:44Z")
This issue has been raised three times before (the first by me), but in the wrong forums. me uninstall 9.12 - Adabas-Natural - Software AG Tech Community & Forums Sue Northcott Adabas Manager Communication Client is n… --- ## [Linked Server does not display tables](https://techcommunity.softwareag.com/t/linked-server-does-not-display-tables/199034)
**Author:** [@N\_N3](https://techcommunity.softwareag.com/u/N_N3)\ **Replies:** 2\ **Last updated:** [May 17, 2018, 11:26am UTC](https://techcommunity.softwareag.com/t/linked-server-does-not-display-tables/199034 "2018-05-17T11:26:58Z")
I have tried to create a linked server via CONNX OLE DB provider to ADABAS. Test Connection to the linked server succeeded and Queries with Openquery work. The problem: An explore of the tables under System Catalogs do… --- ## [Server went down while releasing a patch](https://techcommunity.softwareag.com/t/server-went-down-while-releasing-a-patch/198536)
**Author:** [@Bavithra\_Arumugam](https://techcommunity.softwareag.com/u/Bavithra_Arumugam)\ **Replies:** 1\ **Last updated:** [March 15, 2018, 11:16pm UTC](https://techcommunity.softwareag.com/t/server-went-down-while-releasing-a-patch/198536 "2018-03-15T23:16:50Z")
Hello, Server went down while doing a patch release. Is this common while doing the release? Please throw some light on this. Thanks in Advance. Regards, BaV --- ## [Starting second network fails](https://techcommunity.softwareag.com/t/starting-second-network-fails/196914)
**Author:** [@Elena\_BenA\_tez\_LA\_pez](https://techcommunity.softwareag.com/u/Elena_BenA_tez_LA_pez)\ **Replies:** 0\ **Last updated:** [October 25, 2017, 3:12pm UTC](https://techcommunity.softwareag.com/t/starting-second-network-fails/196914 "2017-10-25T15:12:26Z")
Hi, A network is started. When second network (different NET-WORK-ID) is started it fails showing this output message: f80s3 (sag)$ startnet.bsh f80s3 (sag)$ %NETRDI-I-STARTED, 24-OCT-2017 14:56:12, Version 2.1.1… --- ## [Prefetch/Multi Fetch](https://techcommunity.softwareag.com/t/prefetch-multi-fetch/196751)
**Author:** [@Derrick\_Tucker1](https://techcommunity.softwareag.com/u/Derrick_Tucker1)\ **Replies:** 8\ **Last updated:** [October 11, 2017, 7:59am UTC](https://techcommunity.softwareag.com/t/prefetch-multi-fetch/196751 "2017-10-11T07:59:30Z")
Hi, Our Natural/ADABAS environment is setup as follows on the mainframe: One ADABAS database which contains all our Natural Environments (MPM108) Multiple ADABAS databases (Dev, Test, UAT, Production) each in there ow… --- ## [Adabas Manager Configuration Error](https://techcommunity.softwareag.com/t/adabas-manager-configuration-error/196260)
**Author:** [@Ricky\_Li](https://techcommunity.softwareag.com/u/Ricky_Li)\ **Replies:** 3\ **Last updated:** [September 8, 2017, 5:57pm UTC](https://techcommunity.softwareag.com/t/adabas-manager-configuration-error/196260 "2017-09-08T17:57:19Z")
Would anyone here help me? [Next page](https://techcommunity.softwareag.com/tag/adabas-add-on-products/87.md?match_all_tags=true&page=1&tags%5B%5D=Adabas-Add-on-Products)