Bytes > Sitemap > DB2 Database Answers

Pages : 1 [2] 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

551. priviledges in db2
552. How to pass a shell variable to a .sql file
553. Why is the database size is larger than the server disk space?
554. How to Create table using like but with modifications?
555. How to concatenate 3 fields in a where statement see attach
556. Compare 2 identical tables script
557. on IMPORT SQL0437W Performance of this complex query may be sub-optimal
558. Server Crash - Application
559. Querry using Catalog information..
560. Tablespace design for range partitioning tables in DB2 LUW
561. Comparision of 2 identical tables
562. What type of query will return the correct results?
563. How to declare timestamp variable with default as current timestamp not working.
564. how can import data acces to db2 in development center
565. How to view a CLOB Output parameter returned from a procedure in DB2 control Center?
566. Slow running sql stored procedure
567. Hy everybody, i'm getting a error:
568. DB2 z/o query performance?
569. Sql0104n ... Sqlstate=42601
570. Union All causing headache
571. using dynamic SQL in a function
572. How to downgrade db2 9.5 to 8.2
573. I am interested in an answer to a RACF Group issue with an Authid
574. how to identify the all the dbpartitions up and running?
575. DB2 tablespace storage
576. how to get all table names from db2 database schema
577. how to restore Cognos 8 Sample DB2 tables
578. I need to expand a field in a db2 table, must I write a conversion program???
579. Use RID in DB2 z/OS V8.1 to find a row
580. Is there any recomendation on how much the underlying FS be free for DMS containers?
581. System: DB2 luw (unix) v9.5 fp4 - Q-Replication & inplace REORG
582. problem solved: error occurred while initializing the Profile Registry
583. z/OS DB2 Runstats Utility v8
584. i have error SQL Exception in DB2
585. DB2... stored procedures?
586. what is difference between dbms and rdbms?
587. A query on SELECT statement in DB2
588. executes cobol program calling another cobol db2 program
589. How to excecute a .sql file from db2cmd
590. Round off the sacle of decimals in db2
591. Can we move the spaces in the integer column.
592. How do I find the table dependency information for stored procedures in db2
593. Closing a .Net OleDB Reader is taking 250ms on DB2
594. Loading CSV file into DB2
595. db2 activate database results in 1226 - Overflow agent is not allowed
596. How to replace '0'
597. How to drop/find depencies of a user defined function in DB2?
598. Using recursive CTE in stored proc?
599. Having multiple databases in my environment...need to start stop every week
600. To start and stop multiple databases in db2
601. how can i select one row out of duplicates in a table.
602. DB2 Triggers
603. Problem in installation
604. Connecting servlet program with db2 gives an error
605. how to update/delete a row with DB2 within the same table
606. What about "match simple" instruction?
607. How to get column information from db logs
608. DB2 Query Patroller failed
609. does CTE use or create temp tablespace?
610. How do you join rar files?
611. Hello all, I am getting a syntax error (see below) while creating a stored
612. To import bulk data in databse in db2
613. When retrieving the data from DB2 through Excel do we need to catalog the databases
614. How to see the collected statistics on declared global temporary table ?
615. Can we truncate a table data using UDF?
616. Check-pending status in DB2
617. Having requirement to fetch record number 500 to 1000 from a table
618. does alter table add column affect performance
619. unable to create server for remote data source
620. How to solve a DB2 Mainframe database connectivity issue?
621. HADR- NEtwork failure server reboot
622. DB2 data from AIX to Windows
623. Calling a DB2 stored procedure from a trigger
624. DB2 upgrade 9.1 to 9.7
625. SQL1024N. A database connection does not exists. sqlstate08003
626. dsn1copy
627. What is the best practice for storing data in multiple time zones?
628. How to select a huge table in a readable format?
629. help required on IMPORT Command
630. How to prevent the insertion of duplicate entries in DB2 tables.
631. How to grant SYSADM privileges to user db2admin ?
632. Connect drupal-DB2
633. Error when trying to replace one sub-query
634. DB2 Bind Variables used in queries
635. is select statement considered as a transaction ?
636. How to change ? to -?
637. db2 :insert xml clolumn failed, HELP!
638. How to create db2 Database programmatically in vb.net
639. DB2 9.5 fix 4 - slow call of procedures ( SYSPROC.ADMIN_CMD, ADMIN_GET_MSGS ... )
640. Auto Update a table
641. Create DB2 Database When Application Runs First Time Development in Vb.net
642. db2 9.4 fix 4, delay between call of procedure inside of a procedure?
643. Inserts and deletes occasinally out of order when read using db2ReadLog API.
644. back up DB2 use TSM
645. DB2 Database Creation. At Application Startup Time
646. DB2 Database Creation. At Application Startup Time
647. How to kill a CICS thread after a online program Abend
648. database technique
649. DB2 Text Search, Update Index fails
650. [DB2] SQLWarning chain holds value that is not a SQLWarning
651. Temporary tablespace managed by database
652. Need to find when the customers next vehicle purchase occured in less than 1 yr
653. DB2 Client on Solaris fails to connect to DB2 Server on Linux
654. Creating function in Db2 (version 8) on mainframe
655. Concatenation in case of case expression
656. Troubles with 16 level nested stored procedure
657. db2audit command z/os db2 8.2
658. ALTOBJ (sql-stmt parameter size)
659. SQLERRMC empty on bind error
660. how to read exported files?
661. Data Base Replication Product and problem acessing data bases
662. How to create table in db2?
663. Sql storedprocedure return no error code
664. Error CPD3E34 DDM TCP/IP communications error occurred on recv() — MSG_PEEK
665. Code level Mismatch
666. DB2 UDB 9.5 FP2a is not using the best index
667. creation of 32 bit instance on 64 bit System DB2udb v9.5
668. Find DB2 job name from system tables in DB2 database
669. Using a Stored Procedure to Update data on AS400 DB2 database from VB.NET application
670. Returning max summarized amounts
671. Import specific colums
672. Attempting to simplify a complicated SQL statement with CASE expression
673. DB2 HADR creation get failed
674. Using returned results from a stored procedure
675. Manual bufferpool flush
676. Execute a DB2 command from JAVA.
677. Querry Execution time
678. Db2 stored procedure fetch multiple rows
679. Last Mon to Sun
680. Group / max
681. Split function in DB2 Version 5 Release 4
682. db2diag.log doesn't capture deadlock
683. Multiple condition trigger
684. Identifying through many columns
685. Wildcards in DB2 SQL
686. Java application against Oracle to DB2 migrated Databases
687. How can I find time/timestamp of instance creation on DB2 LUW?
688. DB2 via Clist
689. Db2 error SQL0901N SQLSTATE=58004 : Reason "Sdir len bad: 1542!=1520+14"
690. Query to Search Data
691. Error SQL0206N
692. Compare DB2 source db and target db after replication/HADR
693. Running Sql script from DB2CMD
694. Connecting to DB2 database on remote server (UNIX)
695. DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130 in db2diag.log
696. Migrating from AIX DB2 V.8.1 FP 13 to WINDOWS DB2 V8.1 FP 9
697. What are the pre-requisites to install IBM db2connect Version 9.5 FP2
698. db2move from DB2 AIX to Windows
699. How to pass a variable as a parameter to DB2 database from shell script
700. DB2 trigger error
701. snapshot_statement stmt_text unicode problem
702. DB2 9.7 High response time on 50 concurrent users
703. 32 to 64 bit in HADR env
704. Select only a portion of the resulting rows
705. DB2 Populate Date Dimension proc
706. substring command not taking $ symbol in string
707. Create db2 table directly by importing flat file without prior db2 table existing
708. Getting Error sql0338n
709. How to get the stored procedure information?
710. hw to get the stored procedure information?
711. Db2cmd error
712. MQT with MQT
713. Performance Problem with Order by Clause in DB2
714. BAckup online with include logs fails !!!
715. How to write a stored procedure?
716. locks, transactions and stored procedures
717. Return union result in one row?
718. SQL1336N and DB2 CONNECTIVITY PROBLEM. What am I doing wrong?
719. Journals in DB2 Server Edition???
720. Migrate DB2 database from Solaris to Red Hat Linux
721. How to calculate size of partition in DB2
722. MQT in DB2 V9.1
723. Problem in fetching procedure text
724. Problem with cursors
725. what is bufferpool in db2?
726. Urgent - DB2 Function
727. i am getting error of SQL0811N in db2 stored procedure. please help its urgent!!!
728. MERGE STATEMENT IN UDB vs z/OS
729. db2 user account deleted accidentally
730. Using LIKE to compare input to column
731. how to load a Db2 table from a compressed file which is an discarded output of REORG
732. error in Stored procedure while using cursor
733. A long string as a Input parameter in procedure
734. List of ALTER Commands which needs REORG to be issued
735. Improving a SQL statement
736. Data export from db2
737. How to connect db2 to java
738. Sort table names by foreign key dependencies in a schema/Database
739. From Oracle to db2 Federation - db2 "crash"
740. Problems querying tables in federated database
741. How to insert X rows into a table from a Select clause?
742. Difference in record counts
743. DB2 cast issue in UPDATE with parameter marker
744. -802 error for count(*) query for a DB2 table
745. Viewing the SQL behind a View in 9.5
746. Database exception while running a batch program on Db2 V8.
747. Which function has TOTAL equivalent to Oracle's TO_CHAR?
748. Connecting to DB2 v7.1 from .NET ?
749. Updating only the year in a date
750. Alter an index in DB2
751. Compare multiple result sets
752. How to connect from DB2 V7.1 to DB2 V9.5 ?
753. How can i store the value returned by sql statement in a variable.
754. Merging Two Triggers
755. How to have multiple statements in one query using iDB2Command in .Net
756. Migrating database from DB2 V8.1 to 8.2
757. db2 index reorg status monitoring
758. Db2 9.5 behaviour in Solaris 10
759. Questions with Archival logging for HADR Setup
760. Few Questions with HADR - 1
761. how to detect unavailable tables?
762. Fetch command in cursor is very slow....
763. Struggling with db2 and ASP app -- Calling a stored procedure
764. db2 v9.1 UDF in C, Windows platform
765. The command contains illegal characters or keywords (It does?)
766. Both my application and reorg is slow...
767. No one can answer this question
768. convert 'Apr 19 20:00:03 CDT 2009' string to date
769. Problem with Update Query in db2 9.5
770. Connecting to Mainframes DB using a .NET interface
771. Web Form to Database
772. Set Null Using Java
773. DB2 V9.5 Tablespace -pages missing and Total pg's not equal to useable pg's
774. db2move issue with as400 iSeries library
775. Incorrect "union all" results
776. 2 linked inserts in one statement
777. DB2 table design and performance considerations
778. Difference Between DB2 zOS and DB2 UDB
779. DB2 integer to Varchar autoconversion in Update
780. How to Transmission of Large data accros network?
781. Help required on using FILTER USING in CREATE FUNCTION
782. Loading tables from USS on Z/OS
783. DB2 on delete cascade is not working
784. Single Tablespace or Separate Tablespaces
785. retrieve all table names from DB2
786. Stored procedure, function, very dynamic SQL and casting
787. problem with db2 installation
788. Trigger Problem
789. Migrate db2 express to iseries
790. db2 cross platform restore
791. DB2 Join result columns are unnamed due to different column names used in subqueries
792. Calling a UDF
793. Row Locking
794. How can we convert SMS tablespace to DMS Tablespace (Automatic Storage)
795. help: a speech interface for information retrieval using a .db2 file
796. same fenced user for different instances with different versions of db2
797. Larger DB2 spaces
798. remove newline character from field in exported table
799. Syscat.triggers valid column
800. DB2 Cpu Usage
801. DB2 TableSpace Usage Actual Size vx Allocated Size
802. Asyncronously accesss data using JDBC from DB2 database
803. sending alerts to users
804. Get diagnostics
805. How to recovery a dropped table?
806. db2 upgrade to v8.2
807. DB2 AIX Admin tools ??
808. Is Replication center v8.1 compatible with DB2 v7 Z/OS ?
809. restore database
810. plz suggest reg. cursors
811. plz help- query related to DB2
812. Using a DB2 User Defined Function
813. makefile
814. Updating an indexed column with the same existing value
815. SQL0104 on Update with Fetch
816. Use of OLAP function
817. How do I change Instance in DB2
818. Catalog Local windows DB2 database on AIX machine
819. MS-SQL queries to DB2 conversion
820. Should system temporary tablespaces generally be on automaticstorage?
821. u just click u get some dollars
822. SQL0284N error
823. how can i generate a unique table name at runtime from db2?
824. How do I concatenate strings from a column into a single row in DB2
825. SQL0206N "O.$COID" is not valid in the context where it is used.
826. Online reorg & log full condition
827. SQL Doubt
828. Trigger: After Delete ... for each row behaviour
829. Views and union...
830. passing input paramter of type list
831. diag.log.sav
832. Can we create a sample database on the app dev client
833. Explain of update-statement without commit
834. What the problem with VARCHAR_FORMAT?!?!?!
835. Confused about memory parameters
836. DB2 triggers & Cascading deletes
837. JOIN between 2 tables. No foreign key, just ranges
838. Online backup locking out processes...........
839. UDB Stored Procedure
840. Prepared statement too long
841. Sustain Business with Regular Audits
842. DB2 and CIO DIO on AIX
843. Lock Table and auto commit
844. A blog to lift the fog on Dataphor
845. any documents for 32 bit and 64 bit stored procedure conversion ?
846. Re: SIGNAL ON DELETE AND CAPTURE
847. DB2 DBA required in Vancouver, BC (Contract)
848. Re: SIGNAL ON DELETE AND CAPTURE
849. Java or .NET interpreter startup or communication failed, reason code "2"
850. No access to the SNAPDYN_SQL view
851. Stored procedure Slo
852. How to "LOAD COPY NO" without backup ?
853. DB2 PHP connection issue
854. Query doing table scan when added simple predicates
855. new dba blog
856. Is this an Invalid option? | db2pd -apinfo
857. parallel insertion into a table in DB2
858. NOT ENFORCED RI - what optimization opportunities are missed?
859. DB2 Career
860. SQL0746N: Routine violated nested SQL statement rules when attemptingto perform operation "MODIFY" on table
861. Stored Procedure has no access on a remote file
862. Please review this Explain plan output - need help
863. Uniqueness checking overhead
864. setting optimization level in stored procedure
865. SQL Error
866. db2diag -g db=DBNAME,instance=instname
867. FLUSH PACKAGE CACHE DYNAMIC
868. Load performance on AIX w/ SAN
869. Last access time for index
870. SQL30081N error
871. Multiple databases in one project
872. dsn1copy uses dynamic allocation for multiple pieces
873. Error using old table() in UDF
874. Unable to restore DB2 Database on Linux
875. "WITH RS USE AND KEEP UPDATE LOCKS" An unexpected token
876. 64 bit encoding in CLOB
877. Problems with a simple Trigger :-(
878. sqlqgRouter_conn_lost_cleanup in db2diag.log
879. How can i modify the following query in DB2
880. Linux + DB2 + php
881. Co-releated Update Statement Tuning
882. Overriding database collation in queries for LIKE operators
883. Find SQL in Stored Procedures
884. Getting rid of kuddb2
885. IBMLDAPauthserver/IBMLDAPgroups, DB2 v. 9.5 ppc-Linux
886. Database creation failing on AIX.
887. Migrate schedules from one instance to another in V9.5
888. runaway sqls
889. DBA question on locating partition to which a specific tablespace page exists
890. SQL PROCEDURE on the iSeries
891. DB2 - forcing a table to cache all data in the buffer pool.
892. What is the syntax for finding the Month(number) in DB2?
893. DB2_USE_ALTERNATE_PAGE_CLEANING and HADR
894. db2 doesn't start on windows2003(update from win2000)
895. After adding a tablespace container: DMS rebalancer is active
896. More DB2 Vista NewBee questions
897. Beginner help needed - error connecting DB2-9.1 with RAD7.0
898. HADR - AIX
899. NewBee Express-C Questions
900. How to debug sqc program
901. Backup with include logs option
902. encoding schema in pcap file
903. Assume a bookshop has database with the following
904. Capacity of "Trial"
905. call a SQL Server 2000 stored procedure from DB2
906. Multibyte data passed from OMVS to DB2 stored procedure gets corrupted.
907. Problem with calculate difference between rows
908. capturing optimization level used for certain sql
909. How to get database size in DB2?
910. index usage?
911. DB2 instances in SDLC
912. Troubles with Start database manager
913. Optimal Method for Getting Max Value
914. Dynamic From Clause To Create View
915. PCML and DEXA
916. Max table or database size?
917. db2 questions
918. V9.5 HADR On AIX
919. how to run a COBOL-IMS-DB2 program
920. stored procedures dependencies
921. Query for selecting NON DUPLICATE ELEMENTS in a table
922. difference in performance in two environments for same sql
923. Re: SQL0104N An unexpected token error
924. difference in performance in two environments for same sql
925. Replication Connect Error
926. DB21034E with triggers
927. dynamic sql - prepare statement
928. db2fmd - instance crash
929. Diff in DB2 versions
930. Unique values in column
931. Update using WITH statement
932. SQL1042C An unexpected system error occurred. SQLSTATE=58004
933. Unicode arguments in posstr(), locate() and LIKE
934. Restore Questions (32 vs 64 bit)
935. DB2 federation problem when reconnecting to a remote federated AS/400
936. How is DB2 tables stored?
937. regarding cics
938. db2stop taking time
939. Merge on LUW 9.5.1 - Not Atomic Continue on SQL Exception
940. Restrictions for SSL on db2 express c luw?
941. DB2 Database Administrator
942. DATABASECAPACITY and SMS tablespaces
943. stored procedure to drop tables
944. Health Monitor Invalid history version in header
945. What happens after new function mode
946. java torque nullable columns
947. Possible to manually mark routine packages as inoperative in DB2LUW?
948. adding nullable columns through torque
949. DataServices World features Universal Services, SOA, WOA and cloudcomputing (San Jose, November 20, 2008)
950. SQL3255 on DB2 v9.1 Win32 with db2move
951. java torque save method exception
952. issue on
953. 9.5 LUW, pointers on running 32 bit client against 64 bit server?
954. Question on SQL-based Administrative Task Scheduler
955. Yielding timeslice
956. db2 stored procedure
957. Get the last day of previous business quarter
958. NO FILE SYSTEM CACHING - Automatic?
959. Sigh, Undocumented error - SQL30082N, RC=22
960. Health Monitor - Manual Backup required...why?
961. confusion about cardinality in explain plan node on compressed table
962. confusion about cardinality in explain plan node on compressed table
963. Procedure performance vs Query
964. Re: MDC vs. cluster index: which to use?
965. backup with multiple targets
966. Add a partition to a table that already has partitions
967. Supress SQL0347 (CTE may contain infite loop)
968. update from select
969. SQL30082N Attempt to establish connection failed with security reason"24" ("USERNAME AND/OR PASSWORD INVALID").
970. Set Encryption password and SQL20143N
971. Yellowfin Enhances Business Intelligence Reporting forTelecommunications
972. CTE is not supported by db2advis
973. PHP5 and DB2 9.5
974. Db2 bind issue
975. query help
976. Detected the death of an EDU. Process was 11.
977. reset monitor switches while capturing snapshots with sql functionsor views
978. DB2 and Websphere MQ transaction coordination
979. db2 database pages
980. Solaris 10 Database bufferpool problem
981. sybase post
982. How to determine the isolation level of incoming queries.
983. Unique Opportunity To Join The Elite Group Of Project ManagementProfessionals
984. Select with odbc_exec (php)
985. calling stored procedure from Perl code
986. Syntax error when creating user mapping in DB2 (Data Federation)
987. actual/estimated cost/cardinality of query plan
988. progress bar for runstat?
989. DDF Security?
990. All about memory
991. HADR Status
992. DB2 low CPU low IO (low insert,low update) why ?
993. DB2advis error
994. please help
995. truncate tables in stored procs?
996. How to Give Operating System Security in db2 if not configured duringinstall ?
997. How to view the special registers in db2
998. DB2 V8 String Parsing Question
999. Migration from SYbase to UDB database
1000. Query execution
1001. lfd length & pd length
1002. Block Comment Confusion ...
1003. DB2 - check if product installed on Solaris/AIX/HPUX
1004. DSNL013I & DDF, DB2 9.1
1005. DB2 9.5 SQL Procedure Developer exam 735 prep, Part 2: DB2 SQL Procedures
1006. Connect to Windows DB2 server from unix
1007. DB2 problem, need help
1008. REORG INPLACE -964 ERROR
1009. INPLACE REORG problem
1010. Kernel parameters for db2 v8.2 on Solaris 10
1011. DB2 Client Upgrade Questions ....
1012. HAVING and WHERE clauses: Performance considerations in SQL
1013. how to find middle row of a table?
1014. SQL help
1015. Try ... Catch
1016. Newbie - Partition setup multiple tables
1017. received this error message DB21034E running an ALTER Stmt
1018. Last DB2 to run on Solaris 8
1019. LOAD with COPY
1020. query to retrieve middle row of a table
1021. Difference between byte[] and blob
1022. Advs & disadvs of Self Tuning Memory Management feature of DB2 v9.5
1023. To Execute DB2 commands on AIX with a user other than instance.
1024. Collecting DB2 performance results for my thesis paper
1025. Selecting from a Dynamic Table in SQL
1026. Just checking
1027. Dynamic sql statement called in a stored procedure SP
1028. Please explain query intervals output
1029. On-line file backups
1030. Variables in SQL???
1031. outer join table filtering
1032. Row_number() over() not working in SPUFI
1033. SqlException Unsupported ccsid, encoding, or locale: "Cp037"
1034. why is NULLID.SYSSH200 executing so many times
1035. Leading Zeros
1036. DB2LOOK Privileges
1037. multiple databases in one instance
1038. ******GOD OF GIFTS 4 U*********
1039. IF Exists Bad Parser
1040. Re: Include all columns in an unique index
1041. shell script to extract rows from table
1042. Re: DB2 Container behaviour on EMC DMX 3 San.
1043. using setAutoCommit(false) in DB2 and MSSQL
1044. db2 V9.5 SQL1084C
1045. Re: Include all columns in an unique index
1046. Why is my static SQL dramatically faster than dynamic?
1047. IXF Column Descriptor Record
1048. Re: Include all columns in an unique index
1049. Db2 v9.5 - Undefined Symbol while creating an instance
1050. Merge statement: Index on source table
1051. DASCRT Command failed.
1052. Multiplexed Connection
1053. Re: flush package cache dynamic executed from client.
1054. Self tuning bufferpool
1055. Self tuning bufferpool
1056. regarding RAM size and db parameter
1057. Empty Table
1058. Help with query on sparse timeseries data
1059. Net Search Extender Throws Confusing Error
1060. Prepare Statement in DB2
1061. Ondemand
1062. Dropping indexes on a partitioned table
1063. Rows in a DB2 table..
1064. Requirement - Database Architect - State of Oregon - 6 months
1065. Merge Into using 'With UR'
1066. IBatis DB2
1067. DB2 error in DB2 control center
1068. Changing the DB2 Interface Language under Windows
1069. Does V8 of DB2 zOS supports
1070. db2 tablespace restore
1071. db2 table space restore
1072. Interview Type Question
1073. Time related question (Subtime)
1074. Mass Updation of Records
1075. Rows in IXF file
1076. Need example for accessing Resultsets from COBOL DB2 Stored procedures from Java
1077. Deletion from a large table (with two child tables) takes more than an hour
1078. Yellowfin says Java the smart option for Business Intelligence
1079. Clob variables in stored procedures and SQL10003C
1080. Question Regarding Parameters for DB2 COBOL Stored Procedure
1081. Using load/import with global temporary tables
1082. how to force bind option for JDBC in db2?
1083. DB2 equivalent to this Sybase syntax
1084. DB2 Bulk Load via Java/JDBC
1085. Db2 Explain weird results
1086. Call for speakers for DataServices World in Silicon Valley closes September 26, 2008
1087. REORG REPLICATED TABLE
1088. retrieving information from 2 tables
1089. blob and clob
1090. MQT cannot be used for queries with parameter markers?
1091. Project Management 2.0 !
1092. Clob
1093. Primary Key error wrong number of qualifiers
1094. DB2 9.5 equivilent of alternate fixpack
1095. how to ensuring MQT freshness
1096. SQL0101N The statement is too long or too complex. SQLSTATE=54001
1097. DB2 UDB LUW full time positions in California
1098. V9 client accessing V7.2 server
1099. SQL27984W - Some information has not been saved (import create mode)
1100. Delete and concurrency problems