The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

2
votes
1answer
22 views

Recovering a partial PostgreSQL archive

I have $PGDATA/base but nothing else. It was taken from an installation after the postgreSQL service was shutdown, so is clean. Is there any way to recreate the other elements in $PGDATA that allow ...
1
vote
3answers
15 views

How can I enter Mongo as a superuser or reset users?

I'm was playing around with permissions and locked myself out of Mongo database. I'm pretty sure I did this by trying to explicitly add access to a database but instead I overwrote only allowing ...
0
votes
0answers
10 views

Moving the IBM Informix IFMXDATA directory to another machine

I'm a total newbie when it comes to Informix DBs, and I'm stuck with what looks like files that contain an Informix database. I'd like to know if it's possible to add or import these files into an ...
1
vote
1answer
49 views

SQL Server 2012 Compatibility

I'm converting some stuff over to be compatible with SQL Server 2012 and had a couple of questions. I'm taking out all of the sp_dboption commands and making them ALTER commands instead, but there ...
-1
votes
1answer
76 views

Steps to start carrier in Database administration [closed]

Hi I am a fresher and joined in a small software company where they given me the opportunity to maintain their database. Just now I know to query the database,to write stored procedure and learnt some ...
1
vote
1answer
22 views

Remove single quotes from db2 column name

I have following query which i am trying to execute against db2 database server SELECT REPLACE('\'abc\'','\'','') FROM TN_DAY_PROCESS I am expecting the output like abc without single quotes from ...
0
votes
1answer
52 views

Does redundancy exists in this table?

I'm studying a DB course and I found this table: In this exercise, the objective is to determine whether the table has redundancy or not. According to the definition of redundancy Data ...
0
votes
1answer
39 views

Large RAM use after import database - ubuntu server

My new vps has 4 GB of RAM. Before importing database system use about 1,2 GB of RAM. When I import database, about 250 MB sql file, 25000 tables use of RAM goes to 97%. Htop showing 3302 mb in cache. ...
0
votes
1answer
14 views

Pentaho 4.4 Database connectivity issue

I am getting the following in one of my transformations. I am trying to extract data from SQL server and pushing to mongodb. 2014/04/03 13:11:10 - EMPLOYEE TABLE Input.0 - linenr 700000 2014/04/03 ...
0
votes
0answers
33 views

Oracle Enterprise Manger not working correctly

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: Where to find the log file to see what's the ...
0
votes
0answers
16 views

Create replication sql server for DWH [closed]

I have a DWH and I need to make an update once a day from STG Database to DWH I need use replication in SQL SERVER, How I do this?
0
votes
1answer
46 views

SQL Server 2012 T-SQL Health Check Script / Stored Proc [closed]

I'm hoping not to re-invent the wheel. I was looking for a routine server side health check script(s) / Stored Proc(s) for SQL Server 2008+ hoping they work on 2012 that provide information in ...
1
vote
0answers
19 views

Truncating Table Partitions Containing Data and Global Indexes

I have to truncate a partition (392,000 records) of a table with 20.000.000 records. At the moment, I'm making a truncate table and rebuilding indexes. But the table has 37 indexes and it takes 20 ...
0
votes
0answers
32 views

How το find last time database was accessed and the inventory of all application and users accessing it?

Need to find 1- Last time sql server db have been accessed (time) 2- Detail information (the inventory) of all applications and/or users accessing the DB. Explanation:I am doing an inventory of all ...
0
votes
0answers
28 views

Every 30 minutes mysql stuck for 20-30 seconds [on hold]

I have very strong mysql 5.5 computer (Windows server / AWS) . My CPU ~8% ,Disk IO - 0.5% , ~Connection - 800 binlog_format=MIXED, innodb_read_io_threads=64, innodb_write_io_threads=64, ...
0
votes
1answer
18 views

How to scatter/arrange all the tables in database model (workbench)?

I have around 71 tables and if i open them for creating a model in workbench all overlap as below If i use the auto layout under arrange section then max i can get is as below How to auto arrange ...
1
vote
2answers
41 views

Free up disk space on sql server

Assuming I have a sql database server with disk space as follows: D Drive: 10GB (For the MDF file) E Drive: 10GB (For the LDF file) And I have only one database on the server with the following ...
1
vote
3answers
50 views

What are the risks of copying MDF/LDF files without detaching the DB first?

Where DB backups are not available, our support team has been trained to restore using the following steps: Get a copy of the MDF/LDF from a file system backup. Stop the instance. Overwrite the ...
0
votes
2answers
84 views

Is it possible to know how many times a user connected to an Oracle database?

Is it possible to know how many times a user connected to an Oracle database? If possible where we can find this information?
0
votes
0answers
41 views

Help with SQL Server Error “ad Hoc access to OLE DB Provider 'Microsoft.ACE.OLEDB.12.0'”

So we have an interesting issue where users are receiving the following error when attempting to query a view in SQL Server 2008 R2: Msg 7415, Level 16, State 1, Line 1 Ad hoc access to OLE DB ...
1
vote
1answer
37 views

Difference between sql agent account logged in as NTLM and UPN?

Can someone please tell the difference between a sql agent account logged in as NTLM and UPN? What is the difference if the sql agent account is logged in as: domain\username and username@domain.com? ...
0
votes
0answers
12 views

MySQL grant select not working properly 5.1.73-log

I have created new users with GRANTS SELECT but this is not applied and still user have full privileges and can still DELETE, DROP, INSERT. SHOW GRANTS for dbreader; GRANT SELECT ON *.* TO ...
5
votes
0answers
132 views

Why would you use a managed service account rather than a virtual account in SQL Server 2012?

In SQL Server 2012, service accounts are created as virtual accounts (VAs), as described here, as opposed to managed service accounts (MSAs). The important differences I can see for these, based on ...
0
votes
1answer
14 views

How to make up sqlplus login automatically execute a script for Oracle in Linux? [closed]

Some script is invoked automatically want up sqlplus login, don't know what good method.
0
votes
1answer
51 views

How should I config the my.ini(or my.cnf) file for mysql?

Thanks for taking your time to look at my question, and I hope that you can help me with this. I have a Windows Server 2012 server, it has: Memory : 3840MB Ram Processor: Intel(R) Xeon(R) CPU ...
0
votes
1answer
24 views

How to know DB user?

I do use PL-SQL developer tool. I used to log in by using Prodcollops as user name to access database. May I know whether my DB user is same as prodcollops or it just a log in name?
0
votes
4answers
92 views

T-SQL: Complete Database in one table

at a relational data model every logical relation is a single table with values and so on. I know someone who is this too much work and he wants to create only one table which contains all. This could ...
0
votes
2answers
31 views

How to use passwords to protect database data

Hello another newbie question for all the database/web experts out there.... I have read a lot about protecting passwords stored in a database using hashes, salts, encryption algorithms etc. To avoid ...
0
votes
1answer
20 views

Immigrate to file-per-table mode in MySQL

I have 20 MySQL databases and in each there are about 20 tables. All the data is saved in a file called ibData1. Now I discovered about the file per table mode but if I change the value in the my.ini ...
0
votes
0answers
17 views

How to recover data in a MySQL DB?

Log file says: Recently disk space on my VPS got filled up. Now my DB looks corrupted, MySQL error log says: 140319 01:28:57 mysqld started 140319 1:28:57 InnoDB: Started; log sequence number 0 ...
0
votes
4answers
65 views

SQL Server 2005 - 2 sets of backups - 2 maintenance plans?

I did my best to search for an answer to this question and couldn't find a scenario quite like this. I'm a fairly new DBA in the sense that I haven't had a ton of training, I basically took the job ...
4
votes
2answers
140 views

Update Statement takes forever to complete [closed]

I have table around 1250000 records, and 80 columns Table Structure CREATE TABLE [dbo].[Table] ( [Column1] [int] IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL, [Column2] [int] NULL, [Column3] [int] ...
1
vote
1answer
30 views

Why Database use Buffer pool for write operation?

In this case, first we write data in RAM,then same data write in database? Why we need do write operation two time?
0
votes
0answers
31 views

Oracle Merge performance

I've a question about the merge performance in oracle. I work in the business intelligence area of a big company and its quite common to have to move millions of records one side to other. The other ...
0
votes
2answers
53 views

Triggers After Insert and After Update - Good Practice

It is a good practice to have a separate trigger for After Insert and another one for After Update or there is no problem in having both in the same logic? Also from a perspective of performance it ...
1
vote
1answer
41 views

Is there any way MySQL can list relationship cardinality between two entities?

I am working on the project where I have to analyse the MySQL schema. As a part of schema information, I want to list down relationship cardinality between different relations. Does MySQL stores ...
0
votes
2answers
40 views

Recovering mysql innodb table from table.ibd backup file

Just practising DB disaster recovery. As per our back up policy, we do complete disk image back ups every half an hour (on our slave server). Now for a scenario, where some how a table has been ...
0
votes
1answer
37 views

how many 'text' column a table could have in mysql? I have this error “Row size too large (> 8126).”

I'm working on a application which is kinda complex to explain how it works. But this is the situation I'm in, ------------------------------------------------------------------------------ FIELD1 ...
5
votes
3answers
106 views

Bad use of Oracle Tablespaces

I have a doubt about the use of oracle tablespaces. I've decided to define for each schema of the datababase two different tablespaces (one for data, and another one for indexes). The problem is that ...
0
votes
0answers
31 views

how to archive old entries from mysql on rds

I have an AWS RDS MySQL DB. I have ec2 instances and an s3. What I would like to do is only retain 60days old data and archive the rest. I'm still new at this so I'm not really sure what to do. What ...
0
votes
0answers
10 views

ASE 15.03 mixed data and log segements

I have a DB with mixed data & log segments. I also have some log on data device & the other way too.. The target is to have the data & log segments aligned properly , please guide me how ...
0
votes
5answers
149 views

How to determine why a MySQL server has become slow and requests sometimes time out?

I'm working on my first project that makes heavy use of a MySQL database and am struggling to understand performance issues I'm having. Most of the time, responses are returned quickly from the ...
0
votes
1answer
126 views

I have mistakenly deleted Datafiles.

In my production server I have mistakenly deleted datafiles. When I am trying to open the database I am getting an error. The files are not important but the database is not opening up. SQL> ...
0
votes
0answers
45 views

MySQL beginner in troubles

My MySQL knowledge isn't really good. However, I tried to move my websites media folder to an other location and afterwards wanted to update the links in my database: UPDATE wp_posts SET ...
0
votes
0answers
45 views

Firebird-Time Interval- between 2 Dates

I try to select the period of employment for the members in a Company. Example: Date of join: 01.01.2001 Today: 27.02.2014 Now, I want this: 13 years, 1 month and 27 days I have a Statement which ...
-2
votes
6answers
250 views

Missing import function in SQL Developer like MS Access has

At my work we used to use MS Access now we are forced to use SQL developer to create queries and export the data. Details: We can only query to the database We cannot create a new database We use ...
1
vote
1answer
56 views

How to grant rights for a user in DB2 Express?

I have installed DB2 Express on a PC. My user is not an administrator user, however as far as i know, it is possible to grant a user rights, so he can create/delete/modify a database. I have ...
0
votes
0answers
7 views

Tables not created in default tablespace postgresql

I have create a database with default tablespace 'TEST1' instead of pg_default. the owner of the database and the tablespace is postgres. I log in to the database with postgres -d test create a table ...
3
votes
1answer
126 views

Confused about load balancing and horizontal scaling in postgresql [closed]

Please correct me if I am wrong but I guess handling more requests and load by adding more machines or balancing the load between multiple servers is horizontal scalling. So, if I add more servers, ...
2
votes
1answer
80 views

db2 performance issue - large number of IOPS how to determine problem?

DB2 database is on storage. We are using 9.7 Storage administrators reported that today database was doing 5000 IOPS (during past days average number was 300 IOPS). Those are disk operations from ...