The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

2
votes
2answers
321 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 ...
0
votes
0answers
26 views

Managing large database tables, large tables VS seperate databases

In my project I have a system where users sign up and perform daily tasks. Note that I am not a database expert, none the less I am trying to solve a potential issue that may arise. A problem has a ...
0
votes
0answers
15 views

DBCC DBINFO and linked servers [on hold]

I have 2 servers A, B. A has a linked server connection to B. B has a stored procedure that runs DBCC DBINFO WITH TABLERESULTS for a database name passed into it. From server A I can execute the ...
1
vote
2answers
58 views

Sanity Test on Oracle Upgrade Database

My oracle sever has been upgraded from Oracle 10g to 12c. DBA has created a box for that now my question is how developers will perform testing on that.. Can anyone provide me the sanity or unit ...
1
vote
3answers
43 views

DBCC CHECKDB consistency-based I/O error

Running: DBCC CHECKDB(DatabaseName) with NO_INFOMSGS gives me the following error: Msg 824, Level 24, State 2, Line 1 SQL Server detected a logical consistency-based I/O error: ...
2
votes
1answer
22 views

Postgres - Regroup rows with at least one common attribute

I have the following table : Letter | Figure -------|------- A | 1 B | 1 B | 2 C | 2 C | 3 D | 3 E | 4 I would like to group rows that share ...
-1
votes
2answers
118 views

database Compatibility 90 to 100 changing causes any problem

We are planning to change Compatibility level of databases from 90 to 100. Would this cause any impact on application side? If yes then please guide me, what steps or measures we need to look upon ...
0
votes
0answers
19 views

How to access a SQL Server database from other computer connected to the different workgroup? [on hold]

I want to access my database from my office network to home net work (not in teamviewer). Cqn you kindly help me on this?
1
vote
1answer
44 views

How big is my oracle database?

I need to determine the total size of an oracle database. Ideas on improving the following query? SELECT 'DataFiles: ' AS TYPE, SUM (bytes / 1024 / 1024) AS MB FROM dba_data_files UNION SELECT ...
-1
votes
0answers
18 views

how can I show all elements [duplicate]

Hey guys I have a probleme at showing all elements informations .. I have a formulaire where i add elements and quantities, then i calculate the total price orderer by the Id. the probleme is that ...
1
vote
1answer
31 views

Split databases into groups of roughly equal datasize

I am trying to split all databases from sys.databases into 7 roughly equally sized Groups based on data ROWS size. I want a table that contains every database and these databases are in 7 different ...
1
vote
1answer
441 views

The service name is invalid while starting EM on oracle 11g on windows

I am trying to start EM on oracle 11g on Windows. When I performed emctl start dbconsole It shows The service name is invalid more help is available on net helpmsg 2185 and when I wrote net ...
2
votes
1answer
206 views

Plan cache behaviour

Can someone please explain me why the following is no getting cached use AdventureWorks2014 go DECLARE @id INT=43865 SELECT sp.[BusinessEntityID] , so.salesorderid FROM sales.salesorderheader so JOIN ...
0
votes
2answers
144 views

Unable to start Oracle database

We have a oracle database, one data file(users table space) of the instance got corrupt and another data file(containing application data) was deleted due to some issue. The database is in ARCHIVELOG ...
2
votes
0answers
16 views

Is there a configuration option that lets me limit the percent of a hard drive that Cassandra uses?

I'm doing some testing with a small hard disk and I'd like to basically stop Cassandra in its tracks if a write or compaction or any other service brings that usage of the disk above a certain ...
-6
votes
0answers
38 views

Where can I lean database? [closed]

What website can I learn database from? websites like Codeacademy's teaching style ect. tnx for you time.
0
votes
1answer
31 views

PostgreSQL values to unique dictionary

I have table with one billion rows and more than 50 columns. I need to reduce size and speed up queries, backup, exports, etc. Some columns contain f.e. only hundreds of distinct values which are long ...
3
votes
1answer
54 views

When do MySQL DBA need root access

For a MySQL DBA, what operations require root access. I know that we need to be root for installation, starting and stopping services. With DBA’s not having root access, is there a way to perform ...
1
vote
1answer
33 views

PostgreSQL won't allow remote connections

My Postgres installation won't allow me to connect remotely. I set the listen_addresses field in the postgresql.conf to '*' and added the line host all all 0.0.0.0/0 ...
-3
votes
1answer
30 views

Database engine disk access [closed]

Do you know what is the difference between the database engine get rows in a table without and with use of an index in a disk prespective. They way the engine access the table in disk is the same when ...
0
votes
1answer
16 views

File share Witness or Disk Witness

I have 2 SQLServers at production site Windows Server Failover Cluster and 1 SqlServer at DR site. I will add the DR node to existing windows cluster and configure AOAG. So for this should I go for ...
0
votes
1answer
43 views

Open .mdf and .ldf files in Microsoft SQL Server without attach [closed]

I want to open .mdf and .ldf files in Microsoft SQL Server without attach. Are the following steps correct? Add new database with MYDBNAME name. Copy the files MYDBNAME.mdf / MYDBNAME_log.ldf to ...
0
votes
1answer
158 views

Time out while connecting to the database. Current time out value is 30 seconds

I am installing a repository creation utility on a windows 8 x64 bit system and getting the following error: Time out while connecting to the database. Current time out value is 30 seconds When ...
2
votes
1answer
2k views

How to create Postgres DB with case insensitive collation

I am using the postgres version 9.4.1 64-bit on windows 7 64-bit. I need to create DB with the setting "case sensitive = OFF" but couldn't make this work. I refereed already many question on SO and ...
0
votes
1answer
30 views

How to, efficiently, search through many sql dump files of really big size

We have an ads website that the uncompressed(plain .sql file) size of the database is about 30gb. Until now when a user was deleting his classified the classified was completely getting wiped out from ...
5
votes
2answers
132 views

MongoDB vs RDBMS DBA duties

What are the differences between the daily tasks/duties of a Mongo DBA compared to a RDBMS DBA? For example, some sites claim that a MongoDB DBA would not require to do data modelling or designing ...
0
votes
1answer
23 views

Log Backup in AlwaysOn

In our current process, log backup is done by log shipping backup job. Is there any need to configure backup job for transaction log in next AlwaysOn environment ? (If we must configure backup, we ...
3
votes
1answer
1k views

Standby controlfile error

I am doing dataguard. I have manually done a backup for the standby database. It was working fine. Problem arose when I used the standby controlfile. On the primary, I have created a standby ...
0
votes
0answers
9 views

What's the point of Doctrine2 ArrayCollections in OneToMany assotiations? [migrated]

I'm new on Doctrine2 and I'm trying to understand what's the goal of having an ArrayCollection on the inverse side of a OneToMany assotiation. Let's say I have two entities, User and Comment, that ...
0
votes
0answers
14 views

error while creating user with a default tablespace

I am new to Oracle 12 and I don't know how to work with Container Databases (CDB) and Pluggable Databases (PDB). In Oracle Database 12c I created a database with the dbca and I created a tablespace ...
0
votes
2answers
40 views

ORACLE12 - Connect Via SqlPlus

I have a local installation of Oracle Before i can connect directly via SqlPlus but now when i try to connect i have this error : ERROR: ORA-01034: ORACLE not available ORA-27101: shared ...
0
votes
1answer
35 views

In what circumstances I am more likely to benefit from auto update stats async on?

I update statistics on a weekly basis using Ola Hallengren's solution. Based on the article below, I am considering enabling the Auto Stats Async and turning on trace flag 2371. Databases With ...
1
vote
1answer
35 views

What database name should I use to connect Tomcat with my database

I have a dump file in Oracle and I should use Oracle 12c. I installed it, created a database and imported the dump into a tablespace, but I can't connect it with my application on Tomcat. I'm lost ...
0
votes
0answers
47 views

FATAL INS-32012 Unable to create directory - Oracle 12c client installation

I am installing oracle client as Administrator in my Linux machine as a silent mode, I faced issue like this [FATAL] [INS-32012] Unable to create directory: /u01/app/12.1.0.2/admclient64. I don't ...
0
votes
1answer
22 views

Postgresql maintainenace queries fail with foreignkey violation

I maintain a Django app with a postgresql backend, where users post interesting URLs (links) and then either leave replies under these or upvote/downvote them. All this is done via 4 postgresql tables ...
0
votes
1answer
37 views

Database convert character_set_server latin1 to utf8

I am writing about a problem on the character encoding that i have on my site with Magento. In practice, the special characters do not take utf8 and gives me the classic non-coded characters: Ã. ...
1
vote
1answer
226 views

MySQL partitioning table by date and hour

I have a table with a timestamp field. This table will have millions of rows every day so the idea is to create partitions by date and hour. Every day I will delete partitions older than 10 days and ...
11
votes
2answers
8k views

Moving postgresql data to different drive

I am using AWS as my cloud environment. I installed PostgreSQL on the same drive as my root instance volume. I have attached and mounted the second drive to my instance. Now I want to move all my ...
0
votes
1answer
106 views

Oracle: Replace corrupted first datafile

A datafile associated with a tablespace has been corrupted (got truncated to size 0). I don't mind losing the data, because I have a full DB dump which I can import. Now I want to replace this ...
2
votes
0answers
26 views

Materialized Views and Indexes

Is there any way to force PostgreSQL to use an index that I created on a materialized view table? I tried every combination possible of moving the column attributes around to make Postgres to use my ...
-1
votes
3answers
64 views

Exclude databases from automatic full backup [closed]

I have 10 databases on my SQL Server. We do an Automatic Full Backup every day at 00.00. The issue is there are two databases out of the 10 that should not be backed up as these databases are ...
1
vote
1answer
40 views

Data transferring

Is there any practices to transfer data from two databases that have different structure of table ? For example : old system : table [folder] with col: FolderId, name, age, sexe, date, orders New ...
0
votes
0answers
34 views

Oracle database in maintenance mode without patch

I could not enable maintenance mode in oracle database without patch Also I don't have patch(Since I don't have Support Identifier). @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE SP2-0310: unable to ...
2
votes
2answers
193 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 ...
1
vote
2answers
2k views

Achieve log transfer to standby (Data Guard)

I am not able to transfer my archive logs from primary to standby. I executed the following query: archive log list Database log mode Archive ...
1
vote
2answers
577 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 ...
-1
votes
1answer
105 views

compare file-based systems and a relational database [closed]

I don't know the exact difference of both can you please compare file-based systems and a relational database?
0
votes
0answers
26 views

Cannot Start MongoDB

I cannot start MongoDB on Debian(Jessie 8.4 Stable). I generated the keyfile and added the path to the key file to the configuration and uncommented the "auth=true" but when I try to start the service ...
0
votes
2answers
821 views

How to build a table for a private messaging system that supports replies?

I'm writing a private messaging web application in PHP, the application allows replies such that when you view a message, you also get to see to what was that a reply to, and to what was that a reply ...
0
votes
0answers
22 views

SQL Server Job does not execute when scheduled, but does execute manually, how do I get it to run as scheduled? [duplicate]

I am running SQL Server 2014 SP 1 CU 5. The job did work in the past. The schedule is enabled. The account it is running under is an ADS account which has sysadmin rights and has delete rights to the ...