The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

2
votes
1answer
32 views

Migrating Oracle 9i database to MySql database on a different Windows Server

I need to migrate my Oracle 9i database with all its tables from windows server 2003 to MySql on another Windows Server 2012. The oracle database is connected to Visual Studio web project. I have ...
0
votes
1answer
14 views

Multi Source replication on single slave having multiple instances MySQL

i had 1 instance of mysql 5.6 on one server A (Slave S) 1 Mysql installed on server B ( Master M1) 1 MySql installed on server C ( Master M2 ) At Slave end : I have created one more instance by ...
0
votes
1answer
2k views

Oracle Enterprise Manager - Where do I find the error logs?

I'm not familiar with oracle management. The problem is when I try to connect to the enterprise manager through the Web browser I get this error: In english: "Internal Error has occurred. Check ...
1
vote
0answers
65 views

Problem I need to Insert Data every 5 minutes, not working [migrated]

Sorry for being such a Nubb This script is to insert Meteorological data from a weather station. The data comes from this text file online http://www.ndbc.noaa.gov/data/realtime2/IMGP4.txt The ...
1
vote
0answers
9 views

Multiple datasets from multiple applications [on hold]

I have been working with different application such as STATA, SPSS, Excel and R for data analyses of health population. Because each program has different features that I need, I'm looking for advice ...
2
votes
1answer
20 views

Unable to change database owner to a user that is already mapped as user

I ran into this problem. Trying to change a database owner to ; however, I get the following error message when doing so: The proposed new database owner is already a user in the database Now I ...
7
votes
1answer
13k views

What exactly is binding in DB2?

I recently crossed over from being a Java developer to an actual DBA in our company. I am learning the ropes, so to speak, about being a DBA (which is actually somewhat of a new position for our ...
0
votes
1answer
18 views

All actions denied on MS SQL Server on Go Daddy Hosting

i have a website hosted on GoDaddy and I need to create a database for it. So headed to the Databases section and created a MS SQL Database then on my local pc I tried to access the database via SQL ...
2
votes
1answer
35 views

`chown -R` equivalent for PostgreSQL

We occasionally have the problem that, when upgrading some software and database, inexperienced (or overworked, not excluding myself) sysadmins (we don’t have separate DBAs except for Oracle) run the ...
1
vote
1answer
29 views

Understanding the usage of version store in tempdb

We are trying to analyze the growth of tempdb on one of our SQL server 2005 Ent SP4. I know tempdb would need the space depending upon the transactions, and how queries are designed to use it. We ...
1
vote
1answer
17 views

Root Remove Remote % host. My SQL

So i accidentally made it so root can be accessed anywhere remotely how do i revoke the % privilege. Using mysql. +-----------+ | host | +-----------+ | % | | 127.0.0.1 | | ::1 | | ...
1
vote
2answers
238 views

DB2 db2fm proccess

Server is been up for 365 days, however i got some weird repeated procceses. Are these normal? ps -fea | grep db2fm db2inst1 643284 229516 29 May 25 - 212564:06 ...
3
votes
1answer
22 views

SQL Server 2012 - How to Remove Partition on Publisher but not Subscriber?

Is it possible to setup partitioning on a SQL Server 2012 publisher table, so that older data can be removed without affecting the same table on a subscriber table? Table exists on Database A (SQL ...
7
votes
3answers
425 views

Accidentally change database name (SQL Server 2008)

It didn't happen to me YET. But I was thinking about this. I was messing around with my training environment, and by mistake I clicked in the database name, and then I touched the letter A. Let's ...
6
votes
3answers
106 views

Sql Server Service Pack Update Notifications

Is there any option in Sql Server to enable notifications from Microsoft in a way that it sends us emails every time a new service pack is released? I have multiple servers with different versions of ...
1
vote
2answers
32 views

Auto Incrementing column based on another mysql

I have an application which generates invoice_id's. These id's need to be unique. The issue is that a client can have more than one invoice depending on what plan they are on. It could be 2,3 or 4. ...
1
vote
2answers
38 views

Looking for application which will provide to determine project database growth and cost per day or month

I am using SQL Server 2008 for product development Currently application is live with 20 users now if I want to check how my database is growing and how much it will grow in month or year projection ...
1
vote
2answers
136 views

Limiting read access in postgres to few rows

We have a requirement where we want to limit the maximum no. of rows that a select query can return when its done using a particular login. So basically we would like to append a limit clause to any ...
0
votes
2answers
37 views

Listener.ora Location

What is the location of the Listener.Ora file in Windows OS? I need to edit that file and I am not able to locate where it is.
0
votes
0answers
21 views

Real time reporting on Mongo

I have my transactional data store as MongoDB cluster on which I need to setup real time reporting(may be a lag of 2 hours will suffice) Data size - 300GB with 20,000,000 rows and 40 columns and ...
-1
votes
0answers
31 views

Unexpected update/delete on OLTP database in SQL server 2005

We are facing one of the major issue where one of the table on a heavily used OLTP database seems to have updated the records which were not expected the way it works for past 3 years or were ...
1
vote
0answers
30 views

Linked Server vs. Ad Hoc (OpenRowset / OpenDatasource) Distributed Queries

I have an application which needs to grab data from different clients' databases that reside at the client's location. So alongside their normal details such as company name, address etc, I also store ...
0
votes
0answers
122 views

SQL Server Job Database name

I am trying to find and write a query for what database is affected by a SQL Server job. I have checked the following: Get a list of SQL Server Agent Jobs and SQL Server Agent Tables and have been ...
0
votes
1answer
274 views

Update table from calculated temporary table

I have two tables, one containing a set of user ID's, vote direction (-1 or 1) and ID of the object they voted on (casted votes table). In the other table, the object id, upvotes, downvotes and ...
8
votes
3answers
475 views

Where to start with Oracle?

This question only needs one answer: a list of great resources for getting started with Oracle, including Database Administration, PL/SQL and SQL. You may find your question has been closed as a ...
1
vote
2answers
45 views

With LocalAdmin become sysadmin SQL Server

I am a local Admin on my machine. Same old thing, my account wasnt added when SQL Server was installed, and I don't want to have to reinstall SQL Server. I went through this blog and it worked until ...
2
votes
3answers
253 views

How to validate and upgrade my knowledge of SQL Server with MCSA

My story is that I am working now almost 10 years as an administrator, I deal with SQL Server and other IT stuff, most of my knowledge is self taught by reading books, dealings with problems and ...
1
vote
0answers
27 views

Managing logs generated by user

I am developing a web app for my client and there is a section which displays the changes made in the application by any of the user. This section is known as log.It basically stores and displays the ...
0
votes
1answer
172 views

Accuracy of mysqldbcompare vs other tools like pt-table-checksum

I was curious to hear what everyone's experiences are with using mysqldbcompare vs pt-table-checksum( from Percona Toolkit ) to find the differences between two MySQL databases. I have heard that ...
0
votes
1answer
157 views

InnoDB Failure of some kind

I have MySQL 5.5 installed. I tried to install Joolma but it failed. I went into their sql and replace EGNINE=InnoDB with MyISAM and the install worked. InnoDB is listed under SHOW ENGINES; Any idea ...
0
votes
2answers
27 views

'Use <database> ' statement not executing T-SQL

Okay, this seems funny for a simple script: but I really need this small piece to execute well. DECLARE @dbName NVARCHAR(50) SET @dbName = 'rx_lab' DECLARE @SQL02 NVARCHAR(MAX) SET @SQL02 = 'USE ['+ ...
2
votes
1answer
38 views

Create Database and LCK_M_S

We are experiencing issues when creating a database in the SSMS GUI in that sometimes it times out complaining that it could not get an exclusive lock on the Model database. Other times the database ...
3
votes
1answer
26 views

Partially contained databases and Windows Logins - best practices?

In versions of SQL Server prior to 2012, in order for anyone to log in to a database using Windows credentials, you first had to create a server-level login, them map that login to a user for each ...
1
vote
2answers
2k views

MySql InnoDB tables are missing after restarting

I had a MySql database with a few InnoDB tables. After restarting the server, and starting MySql Server again, I connected to the MySql Server using MySql Workbench, and couldn't see the database at ...
0
votes
3answers
54 views

Merge MySQL tables without data repetition

My situation is this: I have several DIFFERENT tables in my MySQL database with the same name columns. Such tables can contain (or not) the same data. What I need to do is a kind of "merge" between ...
0
votes
1answer
565 views

Not receiving archivelogs from production to remote side

I have a scenario in which we have Designed data guard. Where we have 2 standby sides. One standby is located locally and 2nd standby is located on remote side. The distance between local and remote ...
0
votes
2answers
229 views

Need Help maintaining multiple databases for a multi-tenant application?

i need some information about multiple databases for a multi-tenant application ? I am working on a project in which we are maintaining separate database for every company? The Companies Database ...
0
votes
1answer
30 views

Feasibility of Automated and Continuous Performance Tuning in the future [closed]

First a quick background: I'm a software developer, not a DBA and have been developing for more than 10 years. Recently I had to optimize a stored procedure and had to run execution plans, ...
0
votes
0answers
44 views

Column based replication in mysql 5.6

I want to do column based replication which means: In my server, I have table T1 in which columns are A, B, C, D, E I want to replicate this table on different server in mysql 5.6 only, but with ...
-1
votes
0answers
11 views

How to set missing colunms as a null in datastage 9.x.x

I have a sequential file with difference length fields, I want to set missing fields value as a null when I import using datastage, (Not mean set empty fields as a null)
0
votes
1answer
37 views

String to timestamp in datastage 9.1.2

Apologies for asking a question that I suppose is very basic. I'm just starting out with Streams. I'm trying to read a sequential files containing a timestamp field and a value field, like this: ...
0
votes
2answers
119 views

Mysql 5.5.25 must be restarted to connect

We have MySQL v5.5.25 running on Windows Server 2008 R2. Occasionally people are unable to connect, and the only way we have found to fix this is to restart the mysql service. This happens every 2-3 ...
3
votes
0answers
568 views

SQL Developer Data Modeller and Data Dictionary question

I'm not a DBA but I am a (mostly!) competent SQL report writer. Can I trouble you DBAs for some pro-knowledge, please? I can connect SQL Developer to Oracle XE's data dictionary without any problem, ...
1
vote
0answers
47 views

Data compression within Internal Tables in SQL server 2008R2

We are doing downgrade from enterprise to standard for couple of servers which are not using any enterprise features: For one of our TFS(Team foundation server) database TFS_resx, when we ran ...
0
votes
0answers
27 views

Accessing database from a number of servers

I have a few servers that access a database, and I was wondering what is the best way to handle access to the database. Is it secure that each server will be able to access the database, or should I ...
6
votes
2answers
2k views

Unknown Db file format - best way to find out?

A client has given me the data he wants visualised in my project - but I don't know what DB format it's in. He's pretty unclear, also.. I have access to the table structures, but don't know how to ...
-1
votes
1answer
32 views

Unable to start the services of SQL server after Downgrading from Enterprise to Standard

We are performing the downgrade activity from SQL server 2008 R2 Enterprise to Standard. After the uninstall and re-install the standard version, (once the saved system databases were copied to the ...
0
votes
1answer
81 views

Notification when the status on sql server replication is “Not Running”

We have a lot of replications set up. Sometimes for some reason, the status of the replication changes to "Not Running/Expired Soon or Expired". Could you please let me know if there is a way we can ...
0
votes
1answer
531 views

How to revoke DBADM and clean up any related objects from DB2 LUW

This question has started because of us taking copies of production backups and restoring them into lower environments (with scrambled data of course) for developers to practice and/or debug against. ...
0
votes
1answer
39 views

Attaching Database Incorrect name in sys.master_files

I have been moving some databases from SQL 2008 to SQL 2012 using detach and attach method. I correctly map up all the files and the physical and logical names appear correctly in the properties of ...