Application retirement and database archiving
Hi! I have a constantly developing application and i want to archive its DB. The DB tables structures constantly change. My idea is to develop non changing core structures (tables) of production tables. It will be something like physical DataMart. For example if I have client information in Application DB, in DataMart I will have only [...]
Answer Question
| May 22, 2013 10:06 AM
Application acceleration, Archive, Database, Database archiving, ETL, ILM
Hi! I have a constantly developing application and i want to archive its DB. The DB tables structures constantly change. My idea is to develop non changing core structures (tables) of production tables. It will be something like physical DataMart. For example if I have client information in Application DB, in DataMart I will have only [...]
Answer Question
| May 22, 2013 10:06 AM
Application acceleration, Archive, Database, Database archiving, ETL, ILM
ITKE Discussion tool bar
It’s been a few weeks since I had the discussion tool bar. ITKE development can not replicate the problem. Did you experience this problem? How did you resolve it? Thanks Phil 5/7/13 .. added tags that have nothing to do with this task but might get some attention
Answer Question
| May 7, 2013 1:37 AM
AS/400, Database, Development, itke discussion tool bar, Networking, Security
It’s been a few weeks since I had the discussion tool bar. ITKE development can not replicate the problem. Did you experience this problem? How did you resolve it? Thanks Phil 5/7/13 .. added tags that have nothing to do with this task but might get some attention
Answer Question
| May 7, 2013 1:37 AM
AS/400, Database, Development, itke discussion tool bar, Networking, Security
I want to assemble a workstation and I don’t know which correct board to use
I have this task of assembling a workstation, and I have been thinking of what model of system motherboard to use, and what Intel processor type to use and the type of media card to use The workstation is going to be used to hold large amount of data, and stores some high resolution media [...]
Answer Question
| April 26, 2013 2:50 PM
Data Center, Database, Networking
I have this task of assembling a workstation, and I have been thinking of what model of system motherboard to use, and what Intel processor type to use and the type of media card to use The workstation is going to be used to hold large amount of data, and stores some high resolution media [...]
Answer Question
| April 26, 2013 2:50 PM
Data Center, Database, Networking
Database audit trail
If database audit trail is not enabled or DBA is having write access on it, then how we can make sure of the integrity of the data in the database?
Answer Question
| April 16, 2013 6:55 AM
Database, DBA
If database audit trail is not enabled or DBA is having write access on it, then how we can make sure of the integrity of the data in the database?
Answer Question
| April 16, 2013 6:55 AM
Database, DBA
Object-Relational database
I find it always challenging to drop types and tables in object-relational DB Schema. Almost invariably, ORA 02303 exception is thrown. Is there some hidden facts about this?
Answer Question
| April 14, 2013 10:28 AM
Database
I find it always challenging to drop types and tables in object-relational DB Schema. Almost invariably, ORA 02303 exception is thrown. Is there some hidden facts about this?
Answer Question
| April 14, 2013 10:28 AM
Database
Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database?
Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database? I need to access data in an Intersystems Cachè Database from an SQL Server database. Can I do a select in SQL Server from a table in another DBMS system? How can I do it? Data is in a [...]
Answer Question
| April 2, 2013 2:22 PM
Cache, Database, InterSystems, SQL Server
Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database? I need to access data in an Intersystems Cachè Database from an SQL Server database. Can I do a select in SQL Server from a table in another DBMS system? How can I do it? Data is in a [...]
Answer Question
| April 2, 2013 2:22 PM
Cache, Database, InterSystems, SQL Server
webservice and iDB2 connections slow on startup
We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the [...]
Answer Question
| April 1, 2013 2:11 PM
AS 400, DB2 connectivity, i series, SQL Server
We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the [...]
Answer Question
| April 1, 2013 2:11 PM
AS 400, DB2 connectivity, i series, SQL Server
E-voting website
I intend to develop an internet voting website for my department to help with the departmental elections. How do I go about the programming aspect and the core part of database?
Answer Question
| March 27, 2013 11:07 AM
Database, Database administration
I intend to develop an internet voting website for my department to help with the departmental elections. How do I go about the programming aspect and the core part of database?
Answer Question
| March 27, 2013 11:07 AM
Database, Database administration
SharePoint 2010 Capabilities
Using SharePoint 2010 can I create a page with a template of fields that users can fill out (system change requests) and submit generating an email to a dist list? I also want the page to store the request information, so those can check back on status of their system request changes. I have read [...]
Answer Question
| March 27, 2013 1:03 AM
Microsoft Access, Microsoft SharePoint
Using SharePoint 2010 can I create a page with a template of fields that users can fill out (system change requests) and submit generating an email to a dist list? I also want the page to store the request information, so those can check back on status of their system request changes. I have read [...]
Answer Question
| March 27, 2013 1:03 AM
Microsoft Access, Microsoft SharePoint
JDBC in SQL
Need example to retrieve data from JDBC in SQL?
Answer Question
| March 26, 2013 5:27 PM
JDBC, SQL
Need example to retrieve data from JDBC in SQL?
Answer Question
| March 26, 2013 5:27 PM
JDBC, SQL
How to merge all MDB files
I have more than 100 Access 2003 .MDB files and all the files have same structures and tables. I want to merge all to one MDB file.
Answer Question
| March 22, 2013 4:47 PM
MDB, Microsoft Access
I have more than 100 Access 2003 .MDB files and all the files have same structures and tables. I want to merge all to one MDB file.
Answer Question
| March 22, 2013 4:47 PM
MDB, Microsoft Access
Can in-memory computing handle big data demands?
Big data may have met its match as in-memory computing has become one of the top 10 strategic technology trends of 2013, according to Gartner. Used by Google and Twitter, this approach allows easier access to data and provides better analysis. Do you think in-memory computing can handle big data demands?
Answer Question
| April 2, 2013 1:28 PM
Big Data, In-Memory Database
Big data may have met its match as in-memory computing has become one of the top 10 strategic technology trends of 2013, according to Gartner. Used by Google and Twitter, this approach allows easier access to data and provides better analysis. Do you think in-memory computing can handle big data demands?
Answer Question
| April 2, 2013 1:28 PM
Big Data, In-Memory Database
Hiding table tabs
With basic hide when statement I am able to view one or more tabs based on selection. My problem is when I have all but one tab hidden and print there is extra space that represents the other tabs. for example I have a tab table with 6 rows and only row 1 is in [...]
Answer Question
| March 21, 2013 4:26 PM
TabControl, Table Functions, tables
With basic hide when statement I am able to view one or more tabs based on selection. My problem is when I have all but one tab hidden and print there is extra space that represents the other tabs. for example I have a tab table with 6 rows and only row 1 is in [...]
Answer Question
| March 21, 2013 4:26 PM
TabControl, Table Functions, tables
Export/Import database with large blobs in MySQL
Hi, we are having trouble exporting and importing databases with blobs in mysql. We have a development environment and a production environment both running mysql-5.0.45 and want to dump databases with blobs from one to the other. We have tried with many options but nothing works. When importing the databases mysql partially imports data and [...]
Answer Question
| March 18, 2013 6:59 PM
blobs, Database, MySQL, mysql import, mysqldump
Hi, we are having trouble exporting and importing databases with blobs in mysql. We have a development environment and a production environment both running mysql-5.0.45 and want to dump databases with blobs from one to the other. We have tried with many options but nothing works. When importing the databases mysql partially imports data and [...]
Answer Question
| March 18, 2013 6:59 PM
blobs, Database, MySQL, mysql import, mysqldump
Best way to set up longitudinal database
Trying to create a database with enrolled student information and want to query students enrolled for a specific semester who then returned for a different semester – but on a larger scale – who were retained 2nd year, 3rd year, 4th year, etc. Trying to have all my semester data in one table and some [...]
Answer Question
| March 14, 2013 2:25 AM
Microsoft Access, Microsoft Access database
Trying to create a database with enrolled student information and want to query students enrolled for a specific semester who then returned for a different semester – but on a larger scale – who were retained 2nd year, 3rd year, 4th year, etc. Trying to have all my semester data in one table and some [...]
Answer Question
| March 14, 2013 2:25 AM
Microsoft Access, Microsoft Access database
Updates in Access
Can multiple users make updates in Access simultaneously?
Answer Question
| March 13, 2013 3:19 PM
Microsoft Access, Microsoft Access updates
Can multiple users make updates in Access simultaneously?
Answer Question
| March 13, 2013 3:19 PM
Microsoft Access, Microsoft Access updates
Communication link failure. A time-out occurred trying to connect to the iSeries Setup
I have a Linux ODBC that pushes data to the AS/400. When I am trying to connect my ODBC Linux connection, it fails and logs the following error message: [rduser@ebsdbprod ~]$ isql -v misysdb erp0101 [08S01][unixODBC][IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=10060 – CWBCO1048 – A time-out occurred trying to connect to the iSeries [...]
Answer Question
| March 12, 2013 8:59 AM
AS/400, Linux, ODBC
I have a Linux ODBC that pushes data to the AS/400. When I am trying to connect my ODBC Linux connection, it fails and logs the following error message: [rduser@ebsdbprod ~]$ isql -v misysdb erp0101 [08S01][unixODBC][IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=10060 – CWBCO1048 – A time-out occurred trying to connect to the iSeries [...]
Answer Question
| March 12, 2013 8:59 AM
AS/400, Linux, ODBC
Which config file does MySQL use?
Hi, I’m having trouble with MySQL. My OS is IBMi V7R1. We are using MySQL 5.0.45 with zend server 5.6.0. The problem is that the MySQL server works fine in qp2term(shell) but ends immediately after start with zend server. Also, when I check the defaults config file for MySQL I get this message: Default options [...]
Answer Question
| March 5, 2013 2:55 PM
MySQL, MySQL 5.0, Zend, Zend Server
Hi, I’m having trouble with MySQL. My OS is IBMi V7R1. We are using MySQL 5.0.45 with zend server 5.6.0. The problem is that the MySQL server works fine in qp2term(shell) but ends immediately after start with zend server. Also, when I check the defaults config file for MySQL I get this message: Default options [...]
Answer Question
| March 5, 2013 2:55 PM
MySQL, MySQL 5.0, Zend, Zend Server
Query
I have a training database; one table lists employees by titles and training required; the other lists employees by name and training completed. I would like to do a query finding out which training that is required but the employee had not received, how would I create that query?
Answer Question
| February 26, 2013 1:44 PM
Database, Query
I have a training database; one table lists employees by titles and training required; the other lists employees by name and training completed. I would like to do a query finding out which training that is required but the employee had not received, how would I create that query?
Answer Question
| February 26, 2013 1:44 PM
Database, Query
