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